Power Query

Turning off relationship columns can improve report performance slightly

Stop Power BI sending unnecessary SQL queries when using hybrid tables

The maximum value this property can be set to in Premium has been increased

This article shows how to compute ratios when row-level security hides some of the data. If the percentage also includes the hidden rows in the comparison,

Measure how well a column is compressed in Power BI

How to get data from Power BI into Excel and use Excel's Python integration to analyse it

We are excited to announce the Public Preview release of our new Power Query SDK for Visual Studio Code!

This blog post shows how to use a Power BI DAX query to extract data and then email it out to users using Power Automate

Defining different formats for values and totals in Power BI can be achieved with the use of a calculation group which will reuse the original format string.

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…

Using Tabular Editor with Power BI, I show how to create a group with all the required values even if they are not in your dataset!

This week it just happened that two of my consulting clients needed a date dimension table so I started revising my base Power Query template to make sure it was ready to share. After I improved my…

If you have excel data, or user-entered data, you have likely experienced frustration from repeatedly seeing the error message below upon hitting “Close & Apply” or refreshing your …

After last week’s post on measuring Power Query CPU usage during dataset refresh, someone asked an obvious question that I should have addressed: does using a gateway change anything? After a…

This content applies to: Power Query Online One of the most powerful capabilities of Power Query and the M Language is Query Folding (also referred to as query delegation, and predicate push-down). Query Folding allows the Power Query Mashup Engine to push the transformations expressed in an M (mashup) query to the data source, in […]

Power BI has two fundamental ways of working with data: Import mode and DirectQuery mode. In Import mode the data for your reports is…

Recently I collaborated with a number of people from Microsoft and Snowflake to write a blog post on best practices for using Power BI in DirectQuery mode on Snowflake. You can read it here: It bui…

Scenario:  In many cases, when we import data into Power BI, Power Query will automatically add suffixes if there are identical column names. However, even if there are multiple duplicate column names in the table, it will add them in numerical order without recognizing the fields and adding them ba...

Introduction Cbind is a function in R that allows you to bind columns / vectors or tables, not by joining them using a column, but by adding the column to the table in the existing order.   Solution There are use cases where we would like to use this function in Power Query as well. For example when...

Recently I wrote about things you can’t do on the Power platform when querying an on-premises SQL database. Specifically, I wanted to recreate views in a database that gets wiped and recreate…

Data Validation with Power BI is not impossible but messy. Here a script and a couple of calculation groups are used to streamline the process.

Best practices for designing and developing complex dataflows

Power Query Online is, as the name suggests, the online version of Power Query – it’s what you use when you’re developing Power BI Dataflows for example. Sometimes when you’…

When migrating processes you need to compare the outputs thoroughly. Power Query is a great tool to build such comparisons as you can refresh from the source.

If we want to make a dynamic disposition of fields in a matrix and give the user the possibility to select the order in which he can display the fields in rows or columns, we can use the Field parameters feature to achieve this goal. Here are the steps to configure it:

If you try to use SELECTEDVALUE on the visible column of the table generated by the Fields Parameters feature in Power BI, you get the following error: Calc

I still get a lot of questions from various Power BI developers about table storage modes and how table storage modes affect an entire model’s type. Here is a post to summarize all table storage mo…

I have been reading a lot of good feedback of the Power BI May 2022 update especially and the introduction of field parameters. Do not want to go into details what it is, because the official blog post and video gives a good explanation. I would like to highlight this post from Chris Webb's about

You want to merge multiple files with transactional data. The files are saved with the month name, yet contain no date records in the file. Here's how.

The October 2024 Power BI update introduces an inconspicuous yet significant preview feature: Value Filter Behavior. This feature is activated by setting a new model-level property, ValueFilterBeha…