Power BI

In recent years, mental health of professionals has become an increasing concern. Here, I share a 5-step approach to use mindfulness to combat disruptive thoughts & feelings and improve mental wellbeing.

Vertipaq is the actual database engine used in Power BI. It is also the engine used in Analysis Services Tabular and Excel Power Pivot.One of the reasons behind Vertipaq’s great performance is due to the different compression techniques that it applies to the data. The overall purpose of the different compression techniques used is to […]

Contribute to samaguire/TabularEditor3Scripts development by creating an account on GitHub.

Learn how Microsoft successfully drives a data culture for business decision making. It describes their strategy and vision for BI.

Being able to do a data driven report subscription with Power BI and Paginated reports is a common request we hear from many customers. Let’s say you want to send a PDF version of a report to…

This is the second article in a series on the introduction to the EvaluateAndLog function. As I explained last time, EvaluateAndLog can be used to print to the debug output the intermediate result …

Reproducing Robert Mundigl’s variations on bullet charts using Deneb and Vega-Lite.

If you’ve read part 1 or part 2 of this series you’ll know how you can create a Power Automate custom connector to call the Power BI Enhanced Refresh API and get fine-grained control ov…

Do you want to return the next working day in Power Query? There is no build in M-function for this, but this post shows how to create one yourself!

Introduction A key requirement for strong Power BI governance is being able to easily report on usage from logs. There are many ways of getting logs in Power BI and many blogs looking at the variou…

When I'm developing reports, I'm asked multiple times to "hide" the slicers/filters from the report page. Usually this is to make space in the page for other visuals and because customers don't want to use the filter pane for some reason. This happened so many times, and only in the last couple of months I decided to try some things out and get a bit creative with Power BI. I came up with two solutions, which I think work great in these scenarios. Remarks: - This might not working very well if y

I spend a lot of time going through the Power BI documentation to find answers about Power BI features. As always, I look for opportunities to make my life easier when I need to look through of data. What better tool for this than Power BI itself? So, I created a few reports to help

In this article we will build a custom Power BI visual from scratch, we will build a KPI card with selections (interactivity in the…

Building a Custom Power BI Visual from scratch (KPI Card) In this article we will build a custom Power BI visual from scratch, we will build a KPI card with selections (interactivity in the dashboard), drill-through functionality, formatting options and highlighting. The code changes are kept to a m...

A key feature to optimize your #powerbi dataset refresh is to partition your dataset tables, this will allow a faster & reliable refresh of new data simply because with partitions you can divide the …

It started with @shan_gsd‘s tweet about Year 2022 Week 33 of the Workout Wednesday and @CJMajka‘s reply “A dumbbell chart in #PowerBI?! That is kind … Read More

One feature of Power BI incremental refresh I’ve always been meaning to test out is the ability to create your own M queries to work with the “detect data changes” feature, and la…

Refresh specific tables in your Power BI dataset using a Power Automate custom connector

I love the new Power BI Enhanced Refresh API: it allows you to do things like refresh individual tables in your dataset, override incremental refresh policies, control the amount of parallelism, ca…

This article describes the IN operator in Power Query. It checks whether a value equals one of many and is meant to simplify your code.

If you’re reading this blog, odds are you’re already familiar with the Power BI documentation. If there’s a feature in Power BI, there are a set of articles that describe its capa…

This post is a running collection of tools that I use for formatting and highlighting code in my blog. The code that I share mainly pertains to Power BI, but includes also Python and C#.

Creative labelling is often necessary in order to overcome specific formatting limitations, or just to have clarity on specific metrics.

In this post, I explain why External Tools are necessary & discuss the challenges in adopting them.

Since the start of the COVID-19 crisis, we are bombarded daily with graphics depicting exponential and rolling trends. These analyses are a powerful way to reveal trends in variable, incomplete and discrete data; however, interpreting them is more difficult.

This post describes the purpose of Coalesce and shows how you can simplify your M-expressions by removing unnecessary code.