power query

The Power Query Editor Remove Rows function can help to prepare your data sets to create meaningful reports. Follow this tutorial to learn more.

There’s an old joke about “Export to Excel” being the most important feature of any BI tool. In fact, I’d say export to Excel is one of the most important features of any en…

This content applies to: Power Query online There’s a new operation available for the Group By transformation in Power Query Online: percentiles. To see how it works, let’s see a simple example.  Consider the following Excel table containing information about invoices from different countries:  If you connect to this table from a Power BI or […]

A quick tutorial about how to add or modify static data tables (i.e. those created with Enter Data) using Tabular Editor 2 or 3.

An article on the new catch keyword added to the Power Query language for the try catch statement

If you’re using the new Parquet connector in Power BI there’s a chance you will run into the following error: Parameter.Error: Parquet.Document cannot be used with streamed binary value…

TL;DR, you can incremental refresh PowerBI using Parquet files stored in an Azure Storage without using any Database in the middle, you can download sample pbix here I am using this blog post by Gi…

Connecting to data sources in Power BI can be very easy. But when you need to call three end points to get to your data with Secrets, Client IDs and Bearer

Hey folks, if you know me, you probably know I am very interested into playing, watching or talking about football (or “soccer”). After decades my home club finaly reached again the seventh German ‘Bezirksliga’ and a German community platform and news publisher “FuPa.net” about amateurs football was looking for suggestions how to split the league. So I decided to make my suggestion and building a Power BI report to help me and also make it visual. Today we will learn about the German football leagues, Power BI, Geocoodinates and how to calculate distances, Power BI Bookmarks, how to use custom functions and make API calls in Power BI and to get some webbrowser content using Power Automate Desktop.

You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I recommend you do. But did yo…

Some time ago I wrote a post about how optimising for CPU Time is almost as important as optimising for Duration in Power BI, especially if you’re working with Power BI Premium Gen2. This is …

List.Accumulate is a powerful function that allows you to perform transformation multiple times. Learn how its use can save you many steps!

Sometimes people ask questions about how to order columns in Power query, mostly for Queries with Lots of Columns. We can reorder column Name with Drag and Drop or use Move in GUI to change the column’s order, but it is also possible to reorder via code. In this post, I will show how to Read more about Sort Column Name in Power Query via M Code[…]

In this blog post I show how you can use the IN condition in Power Query within Power BI instead of having to use multiple conditions.

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

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.

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!

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 […]

Learning to consume APIs in Power BI has been a game-changer for me. As I started making my first API requests, a world of…

This article provides information on how to enable query folding against queries that use the Value.NativeQuery function.

You want to return the nth business day from a date in Power Query. And this offset should take into account holidays and weekends. It's a common requirement

In the last post in this series I showed how to get the status of an individual Power BI dataset refresh. In this post I’ll show how to get the history of a dataset’s refreshes and save…

Query FoldingQuery Folding AuditFunction 1: __QFIndicatorFunction 2: __QFAuditQuery FoldingI will assume you already know what is query folding. If you don't, please read this documentation or watch …

Unpack all the new automation and functionality of Data Source, phData's newest tool from its Toolkit that helps with migration validation.

In September 2014, I wrote a blog post on dynamically passing parameters from PowerPivot to a SQL Server stored procedure using VBA. Back then, VBA was a real lifesaver. It perhaps still is for many of us. But frankly, I even forgot how to write VBA. Maybe it is time to look at it again. … Continue reading Dynamically Passing Parameters to a SQL Stored Procedure in Excel 365 Using Power Query