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

Transform a local into a global Power BI solution – Dataset discoverability

After everything about sharing content and requesting access to content, it is time to talk about discoverability of content in the Power BI Service. The next blog in the series of transforming a local into a global enterprise grade solution. In this blog, we will look closer at the discoverability of datasets and in particular …

Continue reading Transform a local into a global Power BI solution – Dataset discoverability

Transform a local into a global Power BI solution – Request access to content

Third blog in the series on Transform a local into a global Power BI solution. After covering the general differences between small scale and enterprise solutions and last week all about content sharing, it is time to elaborate on a new topic. Previously we talked about how content should be shared, but now we will …

Continue reading Transform a local into a global Power BI solution – Request access to content

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

Recently I started a blog series on different topics that come into play when you want to transform a local (small scale) solution into a global (enterprise) solution. I started this series explaining some typical differences between local and global solutions as you can find in the introduction post of this series. This week, the …

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