power query

My favourite – and it seems many other people’s favourite – new feature in the February 2022 Power BI Desktop release is support for more datasources (including SQL Server, Azure …

Let's see how to create your own data types in Power BI! This is a follow up of Part 1, where we learned how it's done in Power Query.

With Power Query we can get the Date and Time of the last refresh, or the date modified. This post will show you how.

Azure Data Explorer has a data type called dynamic which can be used to hold scalar values as well as arrays and property bags; you can read about it in the docs here. For example (following on fro…

Transforming multiple columns at once with reference to existing columns can leave you with very slow queries. Learn how to do this fast.

Tabular Editor is not only a helpful tool for developing DAX. You can also use it to view & modify your Power Query M code, without ever opening Power BI desktop . Furthermore, there also exists a formatter for Power Query that can help you make your code easier to read & manage. He

At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query queries. These methods are …

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…

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…

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...

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

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…

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

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

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…

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.

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&…

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…

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

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"

Tabular Editor and nothing else

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

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

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

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.