Power Query

Learn how to inject descriptions in your Power BI semantic models directly from your Power Query M scripts.

Carlos Barboza is experimenting with visualizing Elon Musk’s activity on Twitter. That looks really great, but I wanted to see more than just quantity; I … Read More

Use the Parquet.Metadata M function to read metadata from a Parquet file

Partition your Delta tables to get good performance for incremental refresh in Power BI

Make anti joins that fold in Power Query by doing left outer joins instead

Unlock the Full Potential of Power BI DirectQuery: Expert Tips to Optimize Performance and Efficiency in Your Reports

Learn the difference between DirectQuery mode and Live connections in Power BI

This step-by-step blog walks you through how to load large datasets in Power BI Desktop using parameters.

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

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

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 …

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…

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

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

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…

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

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!

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.

This post describes the purpose of Coalesce and shows how you can simplify your M-expressions by removing unnecessary 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.

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

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

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 …

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…

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.