Power BI
power query
Tables, Numbers, Immutability And Power Query Performance
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…
Creating a Time Dimension using the Power Query Editor in Power BI Desktop
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
Transitive Closure in Power Query
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...
Renaming all the Columns in a Table at Once using Power Query (M Language)
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.
Power Query in Microsoft Flow - Joining Tables
In this post I will introduce one of the most powerful parts of Power Query, joining tables. Its the vlookup part of Power Query.
The AutoSetDefaultInitialCatalog Analysis Services Server Property
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…
Power Query Enter Data Explained
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…
Power Query – Getting the Min Value repeated for all rows in my table
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
Only Get the Last Few Periods of Data into Power BI using Power Query Filtering
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…
Power Query in Flow - Summarising the Data
In this post I will look at the different options we have for summarising the data using grouping and pivoting with Power Query.
The ‘Get Data’ User Experience in Power BI / 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.
Tables in Power Query - how, when and why
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.
Column Quality and Distribution Features are Finally Here
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!
Generate Random List of Numbers in Power BI Dataset Using Power Query
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…
Power Query - Multi-step Function
This post describes how to build a multi-step function in M using a parameter and using create function to build the function code.
Power Query - Custom Handwritten Function
In this post I will write a simple custom handwritten function to perform a calculation, which can then be used in your queries.
Change the T-SQL Script of a Power BI Table without Add/Remove from the Model
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 in Power BI with Power Query
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
Power BI And Case Sensitivity
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…
#PowerQuery – Control the expand columns so it includes new columns
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…
Power Query - Function to Execute an SQL Procedure
This post describes how to create a function that executes an SQL procedure, passing in a parameter and how to avoid the security question.
Power Query - Building functions to fetch web data
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.
Introduction To M In Power Query And Power BI
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…
Power Query – Add Column to see if it is a Number Data Type
Reporting/Analytics Made easy with FourMoo and Power BI
Power Query – Get Started!
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.