Improve my home office setup

As it is not likely that anything will change anytime soon, we are probably working from home for the coming period. Although I had a pretty good home office already and not much to complain about, still I decided to up my game and upgrade my home office. You might think, "huh... normally he writes …

Continue reading Improve my home office setup

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

Will query folding apply to Power BI Composite models?

Recently, I run into a case where we wanted to combine Direct Query sources with imported data. Well, this functionality is actually called composite models nowadays. Having that said, let me start with managing some expectations for this post. The title says composite models, but I have to admit, it is not about the to …

Continue reading Will query folding apply to Power BI Composite models?

Leverage Power BI Deployment Pipelines with Premium per user licensing

At Microsoft Ignite, there were two really exciting announcements when it comes to enterprise features for Power BI. Both directly took my attention, as well as for many others. Obviously, the first one is Power BI Premium per user (PPU) licensing. Secondly, Deployment Pipelines reached General Availability! Two super important features for enterprises and the …

Continue reading Leverage Power BI Deployment Pipelines with Premium per user licensing

Analyze active sessions and cancel refreshes in Power BI

Getting more insights in the telemetry of your Power BI dataset is always interesting. Especially if you share your Power BI dataset for self-service purposes to build new reports on top of your managed dataset, you might want to know who is actually using in and what queries are they executing against your datasets. Besides …

Continue reading Analyze active sessions and cancel refreshes in Power BI

[UPDATED] Power BI icon for Diagrams.net to draft full Power Platform Solutions

It is only a week ago when I posted the icon library for diagrams.net, also known as draw.io, wrote a blog about it and shared with all of you. Now it is already time to give it the first update! At Ignite 2020, Microsoft showed us the new Power Platform Icons for the very first …

Continue reading [UPDATED] Power BI icon for Diagrams.net to draft full Power Platform Solutions

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)

Driving a data culture with Power BI – Part 1 – What is a data culture?

Recently, I have presented a webinar about Driving a data culture in your organization. During this webinar, I presented what challenges you might face, what mistakes are made often and what you can do to drive a data culture in your organization! In this blog, I will introduce the topic Data Culture and elaborate on …

Continue reading Driving a data culture with Power BI – Part 1 – What is a data culture?