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

Integrate Power BI Deployment Pipelines with Azure DevOps

Back in 2019, Ton Swart and I wrote a blog post on Versioning and CI/CD for Power BI with Azure DevOps. Back then, there were not many options available for versioning and professionalizing your ALM story for Power BI. Till today, this blog post is still my most read blog on Data-Marc.com which makes us …

Continue reading Integrate Power BI Deployment Pipelines with Azure DevOps

Extract refresh metrics for your entire Power BI workspace

In the Power BI service, you can easily look at refresh times for an individual dataset or dataflow. There are many different reasons why these metrics are important to you as a dataset or dataflow owner. For example, you may bump into refresh time-outs or unfortunate errors. There are many good reasons to think about …

Continue reading Extract refresh metrics for your entire Power BI workspace

Update: Move dataflows across workspaces

Over a year ago, I wrote a blog about moving dataflows across workspaces using a PowerShell script. Especially useful if you want to move dataflow logic from your development to test, acceptance or production workspace. I received a bunch of feedback on this script and run into some issues myself as well lately. It was …

Continue reading Update: Move dataflows across workspaces

Monitor your On-premises data gateway with Azure and Power BI – Part 2 – Data source connectivity

Lately, I published the first out of two blogs about monitoring your on-premises data gateway. The first blog was all about monitoring your gateway up time but doesn't tell you when one of the connections on your gateway is down. This blog will go in more detail how you can monitor your data source connectivity …

Continue reading Monitor your On-premises data gateway with Azure and Power BI – Part 2 – Data source connectivity

Monitor your On-premises data gateway with Azure and Power BI – Part 1 – Gateway up-time

Power BI includes a very rich set of data connectors to get your data from. Both connectors to on-premises and cloud solutions are provided which sometimes require an On-premises data gateway in order to refresh your dataset in the Power BI service. This additional component, does not have out-of-the box monitoring functionality. But why not …

Continue reading Monitor your On-premises data gateway with Azure and Power BI – Part 1 – Gateway up-time

Manage all your Power BI refreshes in one place with Power Automate (Flow)

As a Data & Analytics consultant, working on tons of different projects, it is very likely that I'm the creator and owner of a whole lot of dataflow and dataset refreshes. Since these refreshes can only be managed by the owner, this limits the rest of my colleagues from updating the scheduled and maintaining the …

Continue reading Manage all your Power BI refreshes in one place with Power Automate (Flow)

Versioning and CI/CD for Power BI with Azure DevOps

Over a year ago, I wrote a  blog about Multiple tier architecture and continuous delivery with Power BI, mainly an overview of the setup and manually creating development and production content. This blog will continue this story in more detail of Power BI CI/CD with Azure DevOps automated deployments. A solution where Dave Ruijter, Ton …

Continue reading Versioning and CI/CD for Power BI with Azure DevOps