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

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

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

Power BI Model Documenter v1.2.0

Time fore new enhancements to the Power BI model Documenter tool! I just presented the new enhanced version of the Power BI model Documenter at the Dutch Power BI User group. Soon, there will also be a recording online of the presentation that I will add to this post as soon as it is available. …

Continue reading Power BI Model Documenter v1.2.0

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

External Tools: Document your Power BI Model

In the Power BI Desktop July release, the External Tools capability was released (in preview). With that 3rd party tooling integration is now possible. Tools such as ALM Toolkit, DAX Studio and Tabular Editor integrate nicely with Power BI Desktop and are capable of writing data in your Power BI model (if new meta data …

Continue reading External Tools: Document your Power BI Model

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

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

Move dataflows across workspaces with the Power BI REST API

Please also check the follow-up blogpost with all recent additions here.  Dataflows are part of the Power BI service for a while now. More and more people are starting to benefit from it in multiple perspectives. The two most heard ones are re-use of data (and logic), but also isolate refreshes to avoid dependencies of …

Continue reading Move dataflows across workspaces with the Power BI REST API