Power BI

Since the incremental refresh is already available with a Pro license, it was time for me to deal with this topic. In the Power BI community, I found out that the known documentation describes how to set up an incremental refresh, but the examples are always based on a single query. In practice, how...

Here are seven tried-and-true tips from other successful Business intelligence adoptions you can’t miss.

Blogging about Power BI, Power Platform and other things I find interesting.

Monkey Tools is an Excel add-in that provides tools that help you build better Excel based models more quickly, and audit those you receive from others.

MonkeyTools Pro is a set of tools to help you build better data models more quickly and using data modelling best practices. They also help you audit what has been done in your data model.

Last week I got an email from one of our readers, with some feedback related to how Monkey Tools’ PivotSleuth works with Measure tables in Power Pivot.

A very quick performance tip: do you have users consuming Power BI reports with Internet Explorer 11 and an older Windows OS like Windows 8.1 or Windows 7? If so, their reports are likely to be slo…

For a solution I’m currently working on, I needed to get a list of all the tables of my solution with some information (name, position and type) of their respective columns. The goal was to e…

In a recent project, I was facing a really weird JSON structure. Each element of the JSON was more or less a dictionary with sparse keys. It means that the field names were different from an elemen…

I’m currently working on the setup of a data quality dashboard and Power BI was our natural choice to display valuable information. For an advanced use-case, we needed to consume CSV files co…

This blog post is the second of a series related to parsing time series about COVID-19, you can find the first one here. When dealing with time series, you should always check if your time series a…

Doubling times are an indicator to measure the growth rate in exponentially growing scenarios. Learn how to calculate them in DAX for display in Power BI.

This article describes how to compute visual totals accurately, in case a measure does not provide the right result at the total level but works correctly i

If you ever spend time looking at DAX generated by the Power BI Desktop Performance Analyser, you may notice a function called KEEPFILTERS appear from time to time. It’s not a function I find…

The new hierarchy slicer allows for data to be sliced based on different levels. This will reduce the number of slicers required on a report page.

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 th…

I was working on a project a wee bit ago that the customer had conditional formatting requirement on a Column Chart.They wanted to format the columns in the chart conditionally based on the average value based on the level of hierarchy you are at.Here is the scenario, I have a Calendar hierarchy as below: Calendar … Continue reading Highlighting Below Avg Sales per Hierarchy Level with SWITCH() and ISINSCOPE() DAX Functions in Power BI

The Pareto chart or diagram analyzes the frequency of problems or causes in a process. Learn about the other 7 Basic Quality Tools at ASQ.org.

A few weeks ago I showed how XMLA Endpoints allow you to connect SQL Server Profiler to Power BI Premium. As well as looking at query execution times this also means you can see in more detail what…

<p>We are excited to announce the public preview of read/write capabilities for the XMLA endpoint in Power BI Premium. </p>

Power platform gateways managment

As always, we love hearing from you to make Power BI better everyday. That is why we have another survey regarding performance for you to provide feedback.

We are excited to announce the public preview of read/write capabilities for the XMLA endpoint in Power BI Premium.