power query

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…

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

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.

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…

#PowerBI #PowerQuery

Reporting/Analytics Made easy with FourMoo and Power BI

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.

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…

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

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

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

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 …

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.

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…

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...

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…

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…

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…

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

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

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…

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.

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…

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...

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

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…

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.