Power BI

Back in January 2020, I visited the Power BI Days in Belgium, where I had a talk about custom page navigation in Power BI. I already started playing around with the Power BI REST API and URLs to cr…

For users accustomed to pivot tables and charts in Excel, Power BI now has a pivot-like experience built-in. Personalization is available in the Power BI Service for any end user once enabled for a report.

I think we can all agree that Power BI is an awesome tool. However, even an awesome software can use some improvements and that is why Power BI team gives monthly updates with all these new cool fe…

Teams Live Events Power BI Dashboard. Contribute to stuartridout/LiveEventsPBIX development by creating an account on GitHub.

How to set up dynamic page navigation and drillthrough in Power BI.

This blog post shows how I created a Power BI report to only show selected pages based on Row Level Security using the new conditional formatting for page navigation

The more complex a Power BI Custom Data Connector gets, the more cumbersome the main Power Query file becomes. Without the ability to make a true “project” structure and include or dire…

If you have been using dataflows, and you have the return value of a query as something which is not in the form of a table, such as a record, list, or value. then you have seen that the dataflow automatically converts them all to tables. There is an explanation about it, and a method…

We have lots of great updates this release! We’re super excited to announce this month that both the decomposition tree and drill through button actions are now generally available. On top of this, we have several new features and updates that will really enrich your reporting: curate featured tables for Excel, new Apply button for the filter pane to apply all changes at once, enhancements to change detection and page navigation action, support for images in buttons, and more!

We are excited to announced general availability (GA) of shared and certified datasets in Power BI.

You asked for the sessions, and we’ve got them for you! View over 50 great sessions from the Microsoft Business Applications Summit 2020. Here’s the Power Platform sessions quick reference blog

I came up with this concept while working on the front end of the Regional Emergency response solution. When trying to templatize some work that was done for a specific customer, I realized that th…

One request that comes up a lot is to be able to provide translations for the tables and columns of your model (especially here in Europe). Up until now this...

This article describes how to optimize a slow Power BI report that has a large number of card visuals, by obtaining the same graphical layout with a smaller

Create variable columns while using Split by feature in Power Query. Create Dynamic Columns while using Split by in Power Query

Format your PowerQuery (M-Language) code with Power Query Formatter

From 2019 – December version, Power BI allows to export existing themes as theme files. With this, rather than creating a theme file from the scratch, we can export existing theme and modify …

I’ve been testing incremental refresh for more than half a year in an enterprise environment and I’d like to share my experience with this feature. You can read a full description of Power BI incremental refresh here. If you have not worked with incremental refresh yet, I recommend that you read the...

In my last tutorial here, you learned how to apply basic time intelligence in Power BI to build your own COVID-19 dashboard following the initial tutorial, in which we imported confirmed and death cases from Johns Hopkins dataset using Power Query. In this tutorial, we will continue our journey and learn how to apply a …

If you are using a date slicer in your Power BI report, a relative date slicer is one of the options to consider for sure. This is a very simple type of slicer to use, but very effective in terms of options that it provides for the user to slice and dice the data. Let's…

Recently, I was presenting my session about AI Capabilities for Power BI to make AI Accessible for Everyone for the Virtual Power BI Days Hamburg. A great event organized by Kathrin Borchert. Part …

<p>See how your peers are creating data-driven businesses, breaking down data silos, reducing costs, and improving results using Azure Synapse Analytics and Microsoft Power BI</p>

My family is a foster family for cats and kittens from the cat shelter where we’ve adopted some of our own cats. Usually a litter will stay with us for a month or two, but it depends on the k…

To build something like this in Power Bi, we don’t need any custom visuals or excessive coding experience. Just a little bit of thinking out of the box :) In Range Bar Charts, data points are built starting from the minimum values per category.