How to use the Query option of the OData.Feed function in Power Query and Power BI

Hello Everyone! In this episode of the “Problem, Design, Solution” series we will be talking about the “Folder” option inside the sources display for Power BI Desktop. This is a fantastic feature …

I am excited to share with you an excerpt from the draft manuscript of my book. You can also add it to your list in Amazon here. I expect to publish more excerpts in the coming months, so please stay tuned, and subscribe to DataChant. Appending Worksheets from a Workbook Excerpted from the draft manuscript …

One of my favourite features in Excel and Power BI is Power Query / M – and I just wanted to share a small trick when you want to filter a table on specific items. Let’s imagine you want to f…

The Advanced Editor is where I LIVE and BREATHE when using Power Query, so welcome to my universe.

This is my second post about List.Zip. First one was about general usage of List.Zip, where I touched question of transforming column types in Power Query. Another scenario where List.Zip can be us…

The environment concept is one of the most important concepts in M, while it is one of the least obvious ones. We'll show why it is important to understand.

The environment concept is one of the most important concepts in M, while it is one of the least obvious ones. We'll show why it is important to understand.

Ages ago I posted an article on unpivoting subcategories using Power Query. The technique is still valid, but what happens when you have a large data set?

Power-Query-Cheat-Sheet - Power Query Cheat Sheet

If you’re interested in cascading parameters and Power BI custom connectors is an option for your project, you should give a try to Navigation Tables. Which soon enough could make their way i…

This is a quick tutorial on how to analyse M-functions step-by-step. Invoking a function will only get the results - see how to follow every single step.

Easy way to expand a complex JSON record without loosing the information that is visible already. Works for star schema and for big flat table

In the past I did create a blog post where I demonstrated how to get the location of a user based on an IP Address What I did forget to elaborate on and what really makes Power BI even more powerfu…

In Excel Power Query, I have a table. Column A has single numbers. I want to mark those records where the Column A value matches a list. A cutdown version of the problem is: let TableA = Ta...

Automatically transform all columns to the types that have been detected in the cells of its first row: Table.TransformColumnTypesToFirstRowsTypes

Over the last couple of years, I have been actively involved in doing Power BI trainings for my clients. Because of that, I am always looking for new and easier ways to explain Power BI concepts to…

Power Query is a very powerful tool. It has a rich interface from which users can easily clean and reshape their data.   Table.Unpivot is one of my favourite feature. It IS a real game changer for cleaning data because business users tend to "build their data in the format that a PivotTable produces...

Learn how to use Power Query like a pro and organize your queries by using this very simple technique. Take your queries and organize them in folders.

How we reduce development lag when building queries in Power Query is a question that came up in my blog post at PowerPivotPro last week, even though that wasn't the main issue.  I thought it might be a good idea … Continue reading →

Do you often find yourself in dire need to compare two tables in Excel? In today’s blog post, we will create an Excel workbook that compares two tables, and highlights the changes in a third table. You can load new versions of the tables, click Refresh All in Excel, and immediately see the changes in …

Bill of materials (BOM) implosion analysis shows where each component is used. See how easily this can be done using M in PowerBI or Power Query in Excel:

Unpivot is one of the most frequent tasks when working with dirty data. Get this new "swiss-army knife-function" for all things unpivot:

Announcement Update: For those who missed out on the webinar Watch the Session Recording for my (Avi Singh) webinar. Click here to watch the session record

How exactly List.Generate works in Power Query? Unraveling the mystery of an algorithm for the better use

A few weeks ago, Microsoft published the Power Query SDK, an extension of Visual Studio, on the Visual Studio Marketplace. It is available for free for VS2015 and VS2017. This extension is a really…