power query

Hi! Today I'm going to show you how to call a power query custom function from file in edit queries. You can now create a repository of custom functions and reuse them from there. Maybe in the near future we can have our m code more organized in our organization. This post will help us get throw thi...

In an earlier post, I showed how to create a function that worked out if a date was a weekday or not. In this example, I've used that function to create a more complex function that adds a number of weekdays to a given date. In Power Query, go to the Edit Queries option and … Continue reading "Power BI: Creating an AddWeekdays function in Power Query M language"

The use of Table.ColumnsOfType is unfortunately not as intuitive as the function may seem. I try to change this with this post.

In part 1 of this series – which I strongly recommend you read before reading this post - I showed how removing columns from a table can make a dramatic improvement to the performance of certain trans…

Understanding what and when / how to use the Data Profiling, Quality, Distribution features inside of Power BI Desktop and Power Query.

Patrick is going bananas with these different ways that Column from Examples can help you shape your data without writing code in Power BI. This feature really helps you to be efficient! Download sample Want to download the sample report? Hit the download button below.

Following on from my last two posts on Power Query performance, I thought I would write about another trick that can make a big difference to your query execution times. It’s actually something tha…

I show how to use the Power Query Editor to create a Time Dimension in Power BI which will allow for slicing of your data by time

In the last few months I have been answering dozens of users’ questions. And there were at least three or four of you with different use cases but the same nominator: I have a table with two columns From and To. And for every distinct value of the column From I want to see all nodes which I can reac...

It is possible to rename all of the columns in a Power BI table at once using some M Language tricks that anyone can learn. Click for full details.

In this post I will introduce one of the most powerful parts of Power Query, joining tables. Its the vlookup part of Power Query.

In Shabnam Watson’s recent blog post on a bug she found when trying to create a Live connection from Power BI to Analysis Services she mentioned that the AutoSetDefaultInitialCatalog server propert…

There are many things you do so often that you don’t think how they work. They just work and that is enough. Not today. I would like to discuss a Power Query query which is automatically generated whe…

This blog post details how to use Power Query with Power BI to repeat a value across all the rows in a table. This is usefull in certain scenarios

Power BI reports can get slow if you have huge amount of data. One of the ways to speed up the performance is to get the smaller part of the data, only the part that is needed for analysis. Most of the times, a date condition is a good filter for that. You might only…

In this post I will look at the different options we have for summarising the data using grouping and pivoting with Power Query.

Conozca la experiencia del usuario para 'Obtener datos' que puede obtener de Power BI / Power Query con sus conectores, parámetros y funciones.

You should master tables in M/ Power Query, in order to become an M ninja. This post shows you all the basic concepts behind this value type.

If you've worked with Power Query in Power BI, you've seen Column Quality and Distribution features already. Today, I've finally received it in the Insider build of Excel!

I've been asked from one of my friends who were trying to create a random dataset for his presentation. There is a great and quick way that you can create a random list of numbers in Power BI using Power Query. In this short blog post, I'll explain how to create this random list. You…

This post describes how to build a multi-step function in M using a parameter and using create function to build the function code.

In this post I will write a simple custom handwritten function to perform a calculation, which can then be used in your queries.

If you have been using T-SQL queries to build the tables of your Power BI data model, you probably know what I'm talking about. Sometimes after a while using a query in the Power BI model, you might change the script and want the change to be applied in the data model. One of the…

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

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…