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

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

Power BI icon library for Diagrams.net (draw.io)

Recently, Dave Ruijter posted a blog about a library containing all the Azure Icons. He shared all icons in his GitHub repository which allows you to directly connect it to the tool Diagrams.net (previously known as draw.io) to draft your Azure architecture. One missing piece in this library was Power BI. Because of that, I …

Continue reading Power BI icon library for Diagrams.net (draw.io)

Migrate Analysis Services models to Power BI using Tabular Editor

Power BI (Premium) now offers a native migration option to Power BI. I recommend first exploring that, before taking this approach. You can find more details here. Also read this blog around migration, how and why. Over the last two weeks, I had the pleasure to work on an innovative case where we wanted to …

Continue reading Migrate Analysis Services models to Power BI using Tabular Editor

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

Data:Scotland – Make AI available for everyone!

Last week, on Friday Septembre 13th, I presented at Data:Scotland. As the name already suggests, in Scotland, Glasgow to be precise. An awesome community event with loads of intresting people and reality well organized. Definitely one to put on your list to visit once! At this event, I presented my all new session about “AI …

Continue reading Data:Scotland – Make AI available for everyone!

Parameterize your data source!

The first step we take in every Power BI report, is connecting to the data source. But maybe you have to change your data source after a while. For example when your transferring your solution from development to acceptance or production. Of course, we can switch data source in the data source settings of our Power …

Continue reading Parameterize your data source!