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

Bring existing tables to Power BI dataflows with Tabular Editor

In my previous blog, I wrote about using Tabular Editor to migrate existing (Azure) Analysis Services models to a Power BI data model. This is pretty awesome already! Once you moved your model to Power BI, you can also start using the functionality of the entire platform. One of the most useful features is dataflows …

Continue reading Bring existing tables to Power BI dataflows with Tabular Editor

How to keep your Power BI dataflows organized and optimized

In this blog I describe a few of the challenges you might face when you have a lot of dataflows. I will describe a few tips and tricks I am applying to sanitize your dataflow approach, organize dataflows and easy to browse through. Dataflows are increasingly used as shared resource or staging layer inside the …

Continue reading How to keep your Power BI dataflows organized and optimized

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)

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!

Inform your end-users by embedding dataflow refresh times in your Power BI reports

It has been a month since my last blog. Busy times with a lot of interesting projects, so less time for writing blogs. Last weekend I was traveling to Power Saturday in Paris. So now I finally had some time to write the blog I was thinking about for a while. Dataflows! Power BI dataflows …

Continue reading Inform your end-users by embedding dataflow refresh times in your Power BI reports

Pimp the dataflows connector in Power BI

Last week, I was challenged by moving my Power BI dataset through the next stage in my DTAP pipeline. I simply wanted to re-assign my connections to the data source in the next stage. In my case, I created a separate workspace including separate dataflows for each stage. Since de dataflows connector in Power BI is …

Continue reading Pimp the dataflows connector in Power BI