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

Power BI Workspace setup – Part 2

After Power BI Workspace setup - part 1, which was mainly about creating your workspace, giving it the right name etcetera, this blog will elaborate on workspace permissions. If you did not read part 1 yet, I encourage you to start at that blog to get the basic setup in place. You might think, permissions …

Continue reading Power BI Workspace setup – Part 2

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

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

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