Power Query

Last week I showed how the new MaxEvaluationWorkingSetInMB registry setting could increase the performance of memory-hungry Power Query queries in Power BI Desktop. In this post I’ll show how…

Increase the performance of Power Query transformations in Power BI Desktop by setting the MaxEvaluationWorkingSetInMB registry key

In this post I will describe how to get previous row data that matches a criteria. This post will demo getting a person's previous score.

The other day I was facing an interesting question "How can I randomly draw ten records from the top 50 for each group using Power Query?" As you may guess, this article also contains the answer.

Enso – a visual and textual functional programming language. - enso-org/ide

Scenario:     In this scenario, the column [City] in my table has some dirty data with some space and case errors. It's also a mixture of abbreviations and full names of the cities. I want to find a way to unify the value of the column ‘City’ into the abbreviation of the cities, and merge this abbr...

Scenario: In Power BI Desktop, when we connect to a .json file, power query editor will transform it automatically if its structure is single. Sample data1: Output in power query: From the APPLIED STEPS we can find that power query editor expands all columns automatically to get this result table....

We are excited to announce a new update to Power Query (PQ) in Excel for Mac – the ability to import data from local files.  We’ve received many requests for this feature after the introduction of PQ query refresh.  Now you can import data from local files including Excel workbooks and text & CSV fi...

Microsoft has partnered with Wolfram to provide new data types, and we are excited to announce their availability for all Microsoft 365 Family and Personal subscribers in English! Getting reliable data from trusted online data sources into your Excel workbook on subjects like cities, foods, animals,...

Mike Allen's Blog - Doing Smarter Things With IT - I’m going to show you how to calculate primes in Excel using Power Query and the Sieve of Erat

There were a lot of exciting announcements at the Microsoft Business Applications Summit this week but if you only watched the keynotes or read the recap on the Power BI blog you will have missed a…

When you use a parameter as the url in a web query, the data source is a Dynamic Data Source and will not refresh in the Power BI service.

The Query Plan visual will allow you to understand what’s happening under the hood of your query with more details than the Step Folding indicator.

Today we are excited to announce the initial availability of Power BI connected PivotTables in Excel for the web. As part of our journey to simplify enterprise data discovery and analysis in Excel, …

This is the first post in a series to create a Star Wars report. This post handles the issue of using a parameter as the url in a web Power Query. This type of data source is referred to as a Dynamic …

How to measure the duration of a Power BI DirectQuery query using Performance Analyzer

For a while now, I have been wanting to have the capability in Power Query to select a query by name PROGRAMMATICALLY. Why? Building a SelectQuery Function would allow me to execute one of multiple “Transform” queries depending on a user selection on the Excel sheet. This will help me process log fil

A lot of us work with Power Query Editor in Power BI and are familiar with its different capabilities that it provides to a report developer. I was recently approached by one of my colleagues who has started learning Power BI, to check if there is a way to implement CONTAINS functionality on a TEXT ...

Learn about how you can set up dataflow automation using the Power Query Dataflows connector in Power Automate!

Hi Power BI Folks! Welcome to our 2nd post here at daxproservices.com.Today, I wanted to share some thoughts about how to keep the house clean when naming the transformation steps of your Power Query …

The low-code capabilities of Power Query can be leveraged to solve highly complex data challenges. I have recently developed a data quality automation solution with it, that takes data quality to the next level. What is the point in purchasing an expensive shelf-product that implements an enterprise data quality automation suite, when you can build…

This post is an overview of ‘Visual Data Prep’ (Diagram View) which is going into General Availability.

Foreword from Imke: Pat Mahoney is a very active fellow super user in the Power BI community and has a very strong interest in all things Power Query. He also (…) Read more

Some interesting new Power Query functionality was released in the December release of Power BI Desktop (it’s also in the build of Excel I’m running) that didn’t get announced in …

I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.

Query folding is a key capability in Power Query. In short, query folding is the process by which the Power Query mashup engine takes the steps defined in the Power Query editor and translates them…

AI Insights in Power Query is a great Premium feature in Power BI. AI Insights Error can occur if you are not fully aware of the settings.

We’re pleased to share that we are now previewing step folding indicators in Power Query Online. These indicators will allow you to understand which steps fold, and which steps don’t. Read on for more.