How to make your Power BI solution support multiple languages

In case you're working in an international company, you might have to deal with multiple languages and cultures at the same time. As not in all countries and businesses, it is common that everyone speaks and communicates in English all day, it can be relevant to support other languages for your Power BI solution. But …

Continue reading How to make your Power BI solution support multiple languages

Connect the Power BI Model Documenter to existing data models in the Power BI Service or Analysis Services

Recently, I've published a new version of the Model Documenter. With that, version 2.1.0 went live. I always try to keep the FAQ up to date and add sections describing typical questions and use cases. However, sometimes it is just easier to write a blog about it to reach a bigger audience, or even record …

Continue reading Connect the Power BI Model Documenter to existing data models in the Power BI Service or Analysis Services

Effect of dataset changes while using deployment pipelines in Power BI

This week, I've presented at two conferences in Europe about Application Lifecycle Management for Power BI. During these sessions at DataMinds Connect and Techorama I've talked and demoed native Power BI deployment pipelines, as well as Azure DevOps integration. One of the topics discussed during the session, is the effect of deployments on datasets by …

Continue reading Effect of dataset changes while using deployment pipelines in Power BI

Power BI Datamarts, should I use it or not?

The first post after my vacation. I was in doubt for a while whether I should write this one or not... given the preview state. Since one of the customers I work for asked me for advise today about Power BI Datamarts, I thought lets do it! They convinced me that it would be a …

Continue reading Power BI Datamarts, should I use it or not?

Sharing individual Power BI dataflows, but how?

Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintained many different dataflows in a single workspace, but did not want to share the entire workspace with others. What now? How …

Continue reading Sharing individual Power BI dataflows, but how?

Script and automate Power BI Backup operations

Basically for every data model, but in particular for large and enterprise-grade data models, it might be wishful to perform backups. Power BI Premium offers a way to perform backup and restore operations for Power BI datasets. This feature, coming from Azure Analysis Services, helps you to take a backup of your dataset logic as …

Continue reading Script and automate Power BI Backup operations

Automate Power BI single table refresh using Azure Data Factory and Azure Automation

Back in February, I wrote a blog on how you can trigger a single table to refresh in your Power BI data model. This blog described how you can achieve this goal using a PowerShell script and the ASCmd cmdlets for Analysis Services, which also works for Power BI Premium. In the wrap-up of that …

Continue reading Automate Power BI single table refresh using Azure Data Factory and Azure Automation

Swap connection from Analysis Services to Power BI dataset

A while ago, I wrote a blog about migrating Analysis Services dataset to Power BI Premium. Back then there were not many options to do so, today there are many more like ALM toolkit. Though, the read is still useful to get the concept behind it and understand the similarities between Azure Analysis Services meta …

Continue reading Swap connection from Analysis Services to Power BI dataset

Do I need Power BI Premium?

Often I got the question from customers: "Can you assign my workspace to a premium capacity?" But frequently they actually do not really need Power BI Premium. It remains to be a difficult topic to decide whether someone needs Power BI Premium or not. Therefore, I decided to setup a decision tree that helps to …

Continue reading Do I need Power BI Premium?

Trigger a single table to refresh in the Power BI Service

If you want to refresh a Power BI dataset, we all know where to find the refresh button in Power BI Desktop as well as in the Power BI Service. By clicking it, you will trigger the entire dataset to refresh. But sometimes it is more convenient to trigger a single table to refresh. If …

Continue reading Trigger a single table to refresh in the Power BI Service