Power BI

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…

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.