Most of the time, you would like to know how the data quality looks like in your tables. Although, this is a process that you mainly check at the time of data preparation, having such report for end u…

This Power BI blog post uses Power Query to show to get an output from a table as a value, which can then be used as part of another M Power Query

Understanding the if statement inside of Power BI / Power Query and how Conditional Columns can be created through the UI and a Custom Column.

As a footnote to my previous post on storing large images in Power BI, I thought all you M nerds out there would be interested to read about a strange performance quirk I noticed while writing the cod…

In this post, we will look at using the Power Query (M) Builder in XrmToolBox, developed by Mohamed Rashid and Ulrik “CRM Chart Guy” Carlsson. This tool is a great way to quickly help build Dynamics 3…

How to change the data source of your queries (file path, folder path, or any other data source parameters) using Power BI / Power Query with the Data Source Settings.

This blog post shows how you can use Text.ReplaceAll in Power Query to replace multiple words at once.

Jason Thomas and Gerhard Brueckl have both blogged on the subject of storing images as text inside a Power BI dataset: http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html https:…

What is the maximum length of a text value in Power BI? It turns out that this is a more complex question than you might think! The maximum length of a text value that the Power Query engine can lo…

This is the full definition fo the new Table.ContainsAnywhere function in Power Query. It covers optoins for search lists, case sensitivity, partial match..

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

Learn How to create a template to Reconcile Accounts Using Power Query for Excel. [with Video, Learn and Earn Activity and Workbook to download]

Mike Allen Systems - Doing Smarter Things With IT -

Two years ago I wrote an article on how to export data from Power BI Desktop to an SQL database. Now there is another way which Power Query can use directly in SSIS.

Mike Allen Systems - Doing Smarter Things With IT -

Another week, another event done. This time it was SQL Saturday Helsinki, where I did two sessions. First session was the Power BI cheat sheet explained, and second Storytelling & interactive r…

June 11-12 are getting near, and it is this time of the year to start getting excited. Microsoft Business Applications Summit is getting close. Do you plan to attend it? I will be glad to meet you in person in one of my sessions that will focus on my Power Query book and the development …

Adam walks through column profiling within the Power BI Desktop. This includes the latest updates with the general availability (GA) within the April 2019 Power BI Desktop release. Demo files: https://guyinacu.be/demofiles

DMVs (Dynamic Management Views) are, as the Analysis Services documentation states, “queries that return information about model objects, server operations, and server health”. They’re also available …

I had an interesting question from one of my book readers and I thought it would make a good blog article. There are many ways of solving this problem, and I blogged about solving a similar problem…

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

The most optimal approach when trying to combine, append, consolidate, stack data using Power BI / Power Query for any data source.

Search through all of your tables' columns with my new Table.ContainsAnywhere function instead of being limited to single columns that you have to specify.

Power Query has more than 80 data sources supported, and Microsoft Exchange is one of those data sources. Although it is not a new data source, however, the power of this data source combined with the…

Cancelling a refresh can take a very long time. I describe a trick that does this in a breeze without loosing your work. Cancel refresh

In this post you learn how to conditionally replace values in Power Query (M) instead of adding unnecessary calculated columns.

A practical example on how to properly combine / consolidate / append Excel Files stored in a Folder using Power BI / Power Query.

As per the April 2019 update, Microsoft has introduced a data profiling capability in Power BI desktop. Data profiling helps us easily find the issues with our imported data from data sources in to Po…

When Power BI dataflows were officially released a few weeks ago there was a new setting for Premium capacities mentioned briefly in the announcement blog post: Container Size. The blog post only says…

Your query doesn't fold in Power Query or Power BI? Don't give up too soon and find out how to make it fold again. Query folding