Power Query

We are excited to announce that the Power Query forum is now available in both Power BI and Power Apps communities!

A quick note for anyone like me who spends too much time looking at the JSON exports from Performance Analyzer in Power BI Desktop: you may have noticed an event called Query Pending that isn&#8217…

This article continues to build on my COVID Case Fatality Rate report for Australia. Something happened with the global source data this week – in short, it was wrong. This is a global database and I am sure there are many people diligently trying to keep the data up to [...]Read More »

We are super excited to announce that digital copies of Master Your Data for Excel and Power BI are now available for purchase!

I love using my data patterns to solve issues and in this post use one of my favourite recipes in order to label duplicates with Power Query.

Learn how to know your dataset better using column profiling, quality, and distribution features of Power Query in Power BI

Learn how to find similar values in the data table based on a similarity threshold and get the similarity score output with fuzzy clustering.

When working with Power Query, you have probably already realized that every expression you write returns a value of a specific type. Usually this will be a primitive type like text, number, or date. (A full list of types available in Power Query can be found here: https://docs.microsoft.com/en-us/powerquery-m/m-spec-types). If for some reason the type of…

Do you need to detect changes or errors between two revisions of mission-critical Excel workbooks? We have just released our 10th app on AppSource that can help you achieve it. Excel Compare (available on AppSource here) is a free Power BI app that compares two Excel files of your choosing and detects differences and errors […]

I admit that the technique I will share with you in this post may not have many use-cases, but it was a crucial component for the Excel Compare Power BI app that we released on AppSource earlier this week, and you can consider reading this post as a technical challenge to evaluate your Power Query […]

Dealing with estimated data often gives you numbers with more precision than you need or trust. Dynamic Rounding can create gains in performance.

Learn how to perform fuzzy grouping and matching in Power BI and Power Query in a few steps described in this article and video

Hi again. This is Maya (you can find me on Linkedin here), with my second post on DataChant: a revision of a previous tutorial. Removing empty rows or columns from tables is a very common challenge of data-cleaning. The tutorial in mention, which happens to be one of our most popular tutorials on DataChant, addressed […]

Learn how to perform the Merge in Power BI and Power Query based on the BETWEEN operation. The sample showed using customized age bands.

The Web.Contents() function in M is the key to getting data from web pages and web services, and has a number of useful – but badly documented – options that make it easier to construct urls for yo…

If you’ve been following some of my recent posts about improving Power BI refresh performance by partitioning tables you will have seen a lot of screenshots that look like the one below: It&#…

There are different ways you can create buckets or groups for your data in Power BI. Patrick shows you how this can be done with Power Query along with a few other options.

An exponential moving average (EMA) is a type of moving average (MA) that gives a higher weight and importance on the latest data points. An exponentially weighted moving average responds more greatly to recent price changes than a simple moving average (SMA), which uses an equal weight to all obser...

How the presence of nullable columns affects the way Power BI and Power Query generate SQL

Learn how helpful can the add prefix and suffix in Power BI and Power Query can be. You will learn it through an example of generating URLs.

In this blog post, I'm discussing whether you should use Power Query in dataflows or in datasets, comparing the two options.

Learn how to extract parts of a text column's value in Power BI using some very simple-to-use transformations in Power Query.

I had the pleasure speaking with Reza Rad on his YouTube live session. Watch out the recording and learn how to harness Power Query and dataflows as a low-code data quality solution and use my Dataflow Snapshots Analysis app.

If you have rows with blank values, you can use Remove Blank Rows or Remove empty to filter them out. learn about their differences here.

We are happy to announce that Office Scripts in Excel for the web is now generally available for all eligible users!   What is Office Scripts? Office Scripts is an automation feature-set in Excel for the web that allows users with all levels of programming experience to automate their repetitive wo...