Power Query

Did you know that you can easily zoom in and out in the #PowerQuery window? Zoom in: CTRL+SHIFT+= Zoom out: CTRL+SHIFT+- Credit to https://lnkd.in/dt-qUqYD... 19 comments on LinkedIn

Learn how to add leading zero in Power BI using Power Query with a very simple step. You will have options to use other formats too.

Replace values in Power Query is easy. Things get more complicated once you add conditions, on multiple columns, needed case-insensitive...

What is the Pivot Columns operation in Power Query? And how can you use it to pivot text values and numbers? Follow along to find out!

I decided to stop writing book reviews here on my blog a long time ago: it’s a lot of work to read a book and write a proper, detailed review and what’s more I don’t like the idea…

Scenario: Suppose I have many columns which both column names and fields look untidy.  I want to do some transformations for them in batches. For example, replace multiple spaces as single space and uppercase each first character of word so that the table would look neater.   Sample data: Expected ...

Creating a journal entry with Power Query. Learn how to create records, sum columns and combine datasets using Power Query.

Learn how to change the data source type of a Power BI report dynamically using Power Query parameters in a step by step guide.

The script for a Power Query function that can be used easily to generate the column value distribution to be used in Power BI.

My post earlier this year on enabling query folding when using SQL queries as a data source in Power Query provoked a lot of interest. This post adds one more useful detail: how to preserve the ori…

Learn how to create a report of column's value distribution in Power BI report using Power Query techniques and enhance data profiling.

Usage scenarios: Sample data table:   #1. Check field if they existed English characters.(upper: 65 ~ 90, lower: 97 ~ 122)   Create a list of all English characters. List.Transform(List.Union({{65..90},{97..122}}),each Character.FromNumber(_))​ Add a custom column with function to compare each cha...

Sample Table In the following scenario, I would like to insert a sum row for each 5 days as an example.   Method 1      let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bdBLCsAgDATQu7iWkon1dxbx/tdoAqWQjrh7yiTjWklFcdlJOUEk7fyRGtUgxaQHuU1GkGrSgjR60yl5+HgEmhRk9/8k+N4z...

Why you need to build a custom connector to use Power BI with REST APIs that use OAuth2 authentication

Earlier this month I published a new and very practical Power BI app on Microsoft AppSource. The app audits Excel workbooks and detects changes and errors. To implement the app I needed to resolve key obstacles that are very common when you import Excel workbooks using Power Query. How do you import the data from […]

You may have noticed that a new dataflows connector was announced in the August 2021 release of Power BI Desktop, and that it now supports query folding between a dataset and a dataflow – whi…

This is not the first time I have shared this concept. In my previous article I showed how it is possible to add a prefix to every column in a table. This article today is slightly different. Today I am removing text from multiple columns all at once using some [...]

This is not the first time I have shared this concept.  In my previous article I showed how it is possible to add a prefix to every column in a table. This article today is slightly different. Today I am removing text from multiple columns all at once using some [...]Read More »

Tables in your Power BI reports don't need to be old-fashioned boring visuals. Check how you can create astonishing tables for your users!

We often have our data spread out in different Excel workbooks and sheets. How do we combine all of them into one table? Let’s walk through an example. We have our data saved in a folder with three files: 2019.xlsx, 2020.xlsx, and 2021.xlsx. You can download the files here. Each file contains three sheets: AC, …

I’m pulling data from GitHub Codeowners into a Power BI report. All was dandy locally, but refresh failed on the PBI service with this:This dataset includes a dynamic data source. Since dynamic data sources aren’t