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

Power BI Governance – New functionality? Govern the implementation in phases

The Power BI team releases many new features in every monthly release, which is an amazing achievement to make it happen every time. Having all this new functionality on your fingertips is a great experience, but not all functionality is production ready yet. Every now and then, functionality is in public preview, which means that …

Continue reading Power BI Governance – New functionality? Govern the implementation in phases

Empower end users to personalize existing Power BI reports with visual customization

Let's start this blog with a scenario. I think all of us, who are a (Power) BI professional, have been in this situation... Once you start a new project, you gain all the requirements for a newly to be created report, interview a representative group of users and you start building the report. After a …

Continue reading Empower end users to personalize existing Power BI reports with visual customization

Power BI Governance – Why you should consider to disable Export to Excel

Recently, I posted a poll on Twitter to vote for new blog topics. One thing that popped-up in my mind, was more on the governance side of Power BI. A topic where I spend a lot of my day-to-day time, but is maybe less interesting for others? At least that is what I thought. Below …

Continue reading Power BI Governance – Why you should consider to disable Export to Excel

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)

Thumbs up or down? Measure Power BI report sentiment with MS Power Automate (MS Flow)

As Power BI enthusiasts and consultants, we are building tons of reports. All with the goal to enable the business to take data driven decisions by providing them with the right information at the right time. Though, if your reporting audience is growing, there is no way to satisfy all your users. Of course, the …

Continue reading Thumbs up or down? Measure Power BI report sentiment with MS Power Automate (MS 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

Move dataflows across workspaces with the Power BI REST API

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 refresh failures from different sources.Same as for your data sources, you …

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