Home/thomas

About thomas

This author has not yet filled in any details.
So far thomas has created 6 blog entries.

Creating Multilingual Power BI Datasets

Multilingual Datasets A little known fact about the Power BI service, is that metadata translations actually work just fine for an imported or DirectQuery dataset within a dedicated capacity workspace (Power BI Premium or A SKUs). You can add metadata translations to a dataset in Premium in two ways: Either through the XMLA read/write endpoint or [...]

By |2021-05-28T11:08:35+00:00August 11th, 2020|Uncategorized|0 Comments

You’re Deploying it Wrong! – AS Edition (Part 5)

This is part 5 of the Analysis Services DevOps blog series. Go to part 4 Release Pipelines In the previous chapter, we saw how to set up a complete build pipeline, that loads our Tabular model from source control, performs a schema check, runs the Best Practice Analyzer and even performs a validation deployment. At [...]

By |2021-05-28T10:59:04+00:00June 20th, 2020|Uncategorized|0 Comments

You’re Deploying it Wrong! – AS Edition (Part 3)

This is part 3 of the Analysis Services DevOps blog series. Go to part 2 Automation Magic with Azure Pipelines Azure Pipelines is the service within Azure DevOps, that lets us automate our builds and deployments. In short, there are two kinds of pipelines in Azure DevOps: Build Pipelines, which are used to validate [...]

By |2021-05-28T10:24:48+00:00October 8th, 2019|Uncategorized|0 Comments

Tabular Editor Tricks – Convert to Legacy

Converting partitions from M to Legacy When building Analysis Services tabular models on top of a Data Warehouse or Data Mart on a relational database, I recommend using the Legacy (Provider) data sources instead of the Power Query data sources available since SQL Server 2017. Unfortunately, Power Query data sources have become the default [...]

By |2021-05-28T09:26:35+00:00July 3rd, 2019|Uncategorized|0 Comments

You’re Deploying it Wrong! – AS Edition (Part 2)

This is part 2 of the Analysis Services DevOps blog series. Go to part 1 Branching strategy and workflow The first thing we need to align before getting started, is what branching strategy to use. While this sounds boring, it’s actually quite important, because it will dictate what the daily development workflow will be [...]

By |2021-05-28T08:58:48+00:00June 28th, 2019|Uncategorized|0 Comments

Tabular Editor Tricks – Object State

If you’re refreshing different parts of your Tabular Model at different times of the day, you may need to know what the current refresh state is, across all objects of the model. For example, running a “dataOnly” refresh on a table, does not automatically refresh calculated columns, hierarchies or relationships. To know which objects are [...]

By |2021-05-28T08:32:13+00:00March 26th, 2019|Uncategorized|0 Comments
Go to Top