Power Query

One new feature that was introduced in the December 2019 release of Power BI Desktop, but which wasn’t mentioned in the release blog post, is the “Diagnose Step” button on the Tools tab of the Powe…

The following is a pretty common scenario that I’ve seen with flat files exported from legacy systems, but it also applies to multiple other scenarios. It uses the M language inside of Power BI Desktop / Power Query, but you can follow along without knowing that much about it. The scenario: a table that contains […]

Learn how to use custom complex functions bulk-wise on your tables: Advanced transformations on multiple columns at once in Power BI and Power Query.

A typical situation in the construction industry the progress data is sourced from multiple system with different format, generally we get two type of reports. Time stamp items My preferred one, th…

This post shows you how to create a custom function for throwing custom error messages in your M code.

Removing the top five rows from a data set is easy in Power Query, but what do you do when you need the number of rows changes? There isn’t a built-in Remove Dynamic Number of Top Rows function. In this post we’ll look at how to set this up...

You can concatenate a list of values in Power BI in two ways; Using Power BI DAX functions such as ConcatenateX, or through Power Query. For some scenarios, there is an advantage in using Power Query to do the concatenation. In this blog article, I'll explain how this works. If you like to learn more…

Learn how to use the US Census API to return the average house hold income. Click here to learn how to call custom APIs in Power BI.

Just wanted to share a M function that I just created to calculate the date from a Year and a ISO week number. The example data is the following Now the function I created can be called with the Ye…

How to and why to use the new AI features for text analytics, vision and more in Power BI Desktop / Power Query from Microsoft.

Learn how to create types from text in Power Query enabling you to dynamically change types via functions for example. Type.FromText

Parameters in Power Query are useful for many scenarios when you want to do something dynamic in the data transformation process. I have previously explained how helpful they are in creating a custom function. In this article, I am showing you another useful way of using Parameters to create dynamic datasets, that you can change…

This is a series of posts and exercises from a recent full-day workshop called Next Level Power BI. Check back for additional lessons and freely post your questions and feedb…

Back in 2018 I wrote a blog post about how to troubleshoot web service refresh issues using a third party tool called Fiddler. It’s still relevant but Fiddler is a complex tool and installing it an…

I'm trying to recreate in dataflows some PQ processes I have in Excel and Power BI, and am suprised by the fact using an M function (e.g. a call to a REST API) is bringing up a reference to "computed entities", which are limited to Power BI Premium. The same function can be called and refreshed on...

Follow the steps in this article to learn how to scrape data from websites, structure it in tables, and use it in a Power BI report. In this example, I show how to create a Power BI calendar of eve…

How to select, rename and reorder columns in Power BI / Power Query using a helper table and M code such as Table.SelectColumns, Table.RenameColumns and others.

Our guest today is Kolyu Minevski, Director, Financial Management and Reporting at Fadata Group. You can contact him here. This article will demonstrate how Power Query can be used for maintaining a simple database/register. Traditionally Power Query is perceived as a tool for data extracting, cleaning and shaping for further analysis. In this case, its …

Learn how to create your own error message for step level errors inside of Power BI / Power Query and when to actually use them.

Using the default option to aggregate joined tables is terribly slow. Read how to speed this up significantly. Performance join.

How to handle different date time zone values in Power BI / Power Query and how to switch those values to a different time zone.

This week I was honoured to be a guest on the Guy In A Cube channel, and for my topic I decided to tackle one of life’s eternal questions: why does Power BI query my data source more than onc…

Power BI comes in three parts, Power Query, Modeling, and Visuals. Power Query is an essential part of data modeling. Learn about it from Gil Raviv's book.

Reporting/Analytics Made easy with FourMoo and Power BI