Another week, another challenge! Summer holidays is the perfect time to run into challenges that you normally would not encounter or simply do not know about because they are fixed before you know. This blog will elaborate on a case I had at a client, where we run into issues with the on-premises data gateway …
Recently, I have had a challenge at a customer, where a central teams maintains many dataflows in Power BI, to store their only and single version of the truth. However, this central team maintained many different dataflows in a single workspace, but did not want to share the entire workspace with others. What now? How …
Continue reading Sharing individual Power BI dataflows, but how?
After Power BI Workspace setup - part 1, which was mainly about creating your workspace, giving it the right name etcetera, this blog will elaborate on workspace permissions. If you did not read part 1 yet, I encourage you to start at that blog to get the basic setup in place. You might think, permissions …
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
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 …
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
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
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)
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
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!
Data - Marc 