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.

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.

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

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

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

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.

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

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

[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 […]

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. …

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 …

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 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 …

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…

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…

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…

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…

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…

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

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

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.

Currently I am working with a project where we extract data from a SQL server – some of the business logic is built into scalar value functions (documentation). Now the magic of PowerQuery enables …