power query

You have lost your column types in Power Query and want to get them back? Check how easy it is to automatically detect and change all column types at once.

Format your PowerQuery (M-Language) code with Power Query Formatter

Create variable columns while using Split by feature in Power Query. Create Dynamic Columns while using Split by in Power Query

If you’ve ever used DAX Formatter to format your DAX code and wondered why there isn’t an equivalent for Power Query/M, then wonder no more: the nice people at Power Pivot Insights in G…

If you have been using dataflows, and you have the return value of a query as something which is not in the form of a table, such as a record, list, or value. then you have seen that the dataflow automatically converts them all to tables. There is an explanation about it, and a method…

It can sometimes be frustrating to work with slow data sources or complex Power Query queries in Power BI Desktop: you open the Power Query Editor, make some changes, click Close & Apply and th…

Reading Time: 4 minutes Postman is a valuable tool to work with APIs, especially when testing and making ad hoc requests outside of an automated production solution. In terms of where a Power BI developer may find Postman useful, it sits somewhere between the documentation’s “Try It” functionality and a more production-worthy solution incorporating tools like Azure DevOps, Logic…

Merging (or, in SQL terms, joining) tables in Power Query is a common cause of refresh performance problems. I’ve often wondered whether there’s anything you can do to optimise the perf…

In the April release of Power BI Desktop the Power Query Query Diagnostics feature was enhanced so that you can now return performance counter data. As the blog post says: When you run performance …

In the last two posts in this series I showed how removing columns from the tables used in a Power Query merge operation can improve refresh performance. In this post I’ll show you a differen…

In the previous post in this series I showed how you can use the Table.Join function and the SortMerge algorithm to get much better performance for merge operations in Power Query – but only …

A typical task when cleaning data is to extract substrings from string that follow a certain pattern. In this post I’m going to describe a method that uses the List.Accumulate function for it. …

[vc_row][vc_column width="1/1"][vc_single_image media="87885" media_width_percent="100"][vc_column_text]The above video walks you through how to perform looping in Power Query in order to iterate […]

The latest blog post explains how to use Power Query to configure and use Power BI Incremental refreshing for the Power BI Dataset

A while ago I wrote a blogpost on how to use Unicode characters in Power BI. In that blogpost I used a recursive Power Query function to convert Hex values to Dec values. A few weeks back one of my site visitors kindly shared his non-recursive version of Power Query function which beautifully does the … Continue reading Quick Tips: Converting Hexadecimal, Oct and Binary to Decimal in a Single Power Query Function

Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.

This blog post shows how you can use Power Query to clean/cluster/group text values in Power BI

This blog post shows how you can use Power Query to clean/cluster/group text values in Power BI

Become an Insider: be one of the first to explore new Microsoft 365 features for you and your business.

When looking to automate the storage of your datasets for the past 2 years, I show how you can do this using Power Query in Power BI

Using Power Query I show you how to embed your username and password authentication in the headers section of an API call.

It’s been a while that I am working with OData data source in Power BI. One challenge that I almost always do not have a good understanding of the underlying data model. It can be really hard and time consuming if there is no one in the business that understands the underlying data model. I … Continue reading Quick Tips: OData Feed Analyser Custom Function in Power Query

Did you know you can retrieve some header data with Power Query that your web call returned? Check out how the function Value.Metadata does this for you.

The default way to retrieve files from a SharePoint folder is slow and getting a single file cumbersome. See functions that improve import from Sharepoint.

This post is an overview of ‘Visual Data Prep’ (Diagram View) which is going into Public Preview.

I am involved with a Power BI development in the past few days. I got some data exported from various systems in different formats, including Excel, CSV and OData. The CSV files are data export dumps from an ERP system. Working with ERP systems can be very time consuming, especially when you don’t have access … Continue reading A Power Query Custom Function to Rename all Columns at Once in a Table