Power Query

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

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…

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…

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

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.

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

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…

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

Here is a real-world M Query scenario recently implemented for a client who has signed contracts in PDF format that offers incentives for sales.

Guest Author: Henk-Jan van Well As a follow up to two older Matrix Multiplication posts here and here, I would like to share with you an alternative query for matrix multiplication using the Cartesian product-functionality within Power Query. This post was contributed by guest author Henk-Jan van Well.  When reading through Gil’s book I got […]

Do yo want to return an (empty) table instead of an error message? This function creates a table string from schema in Power Query.

¿Queres saber sobre los orígenes de datos que utiliza LaData para realizar sus informes? Power Bi Córdoba, Argentina.

Tabular Editor and nothing else

TL;DR - If you're using the Dataverse connector (née "CommonDataService") in PowerQuery/Power BI, try adding the [CreateNavigationProperties=false] as a hint to dramatically speed up the "Evaluation" stage of a data import / refresh. (Note: This only is appropriate as long as you're not "expanding"

This content applies to: Power Query Online Power BI datasets We are excited to announce three new features for the VNet data Gateway! New capability to create VNet data gateway clusters. You can use a cluster of virtual network data gateways to load balance the queries executing on the cluster and to avoid a single […]

I was intrigued why Tableau and PowerBI have a different behavior when operating in a Direct Query Mode ( Tableau call it Live Mode), I always assumed it is just a driver difference, but it seems i…

A few months ago one of my colleagues at Microsoft, David Browne, showed me an interesting Power Query problem with how the Xml.Tables and Xml.Document M functions handle null or missing values. I&…

Learn to extract any step in Power Query. How to extract any single step in Power Query. Extract a step from the middle in Power Query.

I was looking at the output of Power Query’s Query Diagnostics feature recently (again) and trying to understand it better. One of the more confusing aspects of it is the way that the Power Q…

Taking Lists from foe to friend. Lists in Power Query are something many people know nothing about. Power Query uses them all the time even though you may

Recently, we hosted Allision Kennedy on the Raw Data by P3 Adaptive Podcast. During the course of the conversation, our co-host Thomas LaRock expressed

In Power BI there’s a popular custom visual called “Filter by list” that lets you filter a Power BI report by any list of values that you paste into it. It can save you a lot of t…

Learn how to create Ordinal Numbers in DAX and M. These numbers describe the position of something, such as 1st, 2nd, 3rd.

Use Case - Sometimes there will be a need to extract domain names from given URLs. Hence http://www.microsoft.com should give microsoft. Below are some sample cases and the results expected.   Exclusion - Subdomains are excluded from the scope of this. Hence, https://powerbi.microsoft.com which has...

I needed to pull some user data for an app that uses Intercom. While I will probably import the data using Data Factory or a function in the long term, I needed to pull some quick data in a refresh…

When you’re looking at the Log Analytics data for your Power BI Premium dataset, or studying a Profiler trace, you may see a command called ExtAuth in the OperationDetailName column: It is do…