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

#PowerBI #PowerQuery

Since last week's post proved very popular (it turns out people want video - who knew?) I thought I'd post the recording of a presentation I did earlier this year at the Power BI User Group in Welling…

Often web based data is split across multiple pages. This post describes how to use a function to fetch web data from multiple pages by using parameters.

This post describes how to create a function that executes an SQL procedure, passing in a parameter and how to avoid the security question.

Image a scenario where your column in your PowerQuery that contains a table with a set a columns that you know at some point will have more columns added. In the case above I know that we at some p…

Case sensitivity is one of the more confusing aspects of Power BI: while the Power Query engine is case sensitive, the main Power BI engine (that means datasets, relationships, DAX etc) is case ins…

Parent-Child-Hierarchies with multiple parents cannot be created with DAX. But with an M-function in Power Query it's possible if you build the model accord