Power BI Workspace setup – Part 1

Time for a more governance related blog this time. It will be a series of two blogs, where in this first part, I will elaborate on the overall setup of your Power BI workspace and naming. The second part will continue about workspace permissions, sharing and ownership. I feel this is a wide topic and …

Continue reading Power BI Workspace setup – Part 1

Power BI Model Documenter v2

Back in 2020, I released the first version of the Power BI external tool to document your Power BI data model. Since then, I wrote a lot about this topic, such as why adding descriptions to everything is important and various releases of the model documenter. Users encountered various challenges with the initial release of …

Continue reading Power BI Model Documenter v2

Unable to open or download Power BI report, because link to Azure Analysis Services is gone. What now?

Recently, I encountered a situation at a client where the Power BI reports where previously bind to Azure Analysis Services, but now the reports became inaccessible. This was because the Analysis Services model was migrated to Power BI Premium, but the reports where not yet connected to the new data model. Unfortunately, since the Analysis …

Continue reading Unable to open or download Power BI report, because link to Azure Analysis Services is gone. What now?

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

Insights in Power BI dataset parameters and refresh schedule

We have all been in a situation where you want to get more insights in the specific settings for a published dataset. But when this dataset is owned and published by someone else, you have to take-over the dataset first to get all the details available. In this blog, I will elaborate on what is …

Continue reading Insights in Power BI dataset parameters and refresh schedule

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?

Transform a local into a global Power BI solution – Content endorsement

The last blog in the series of transforming a local into a global enterprise grade solution. After everything about sharing content and requesting access to content, and many other topics, it is time to look at content endorsement. A feature in the Power BI service that helps you to easily mark your content as being …

Continue reading Transform a local into a global Power BI solution – Content endorsement

Transform a local into a global Power BI solution – Ownership and descriptions

Time flies when you are having fun and learning, right? Time for the 6th blog in the series of transforming a local solution into a global, enterprise-grade Power BI solution. This episode will be spent on ownership and descriptions, why is ownership important, how to arrange it and how and where to put descriptions and …

Continue reading Transform a local into a global Power BI solution – Ownership and descriptions

Transform a local into a global Power BI solution – Information protection

On to the next topic, which is super important for global, enterprise grade solutions if you ask me. Security and information protection! The fifth blog in the series of transforming local into global Power BI solutions. Good to know up front is that information protection is a feature that not specifically related to Power BI, …

Continue reading Transform a local into a global Power BI solution – Information protection