Power BI

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

A Tabular model can define a measure as a Key Performance Indicator (KPI), thus providing a visual indicator for status and trend. This article describes in

I show how you can use Vertipaq Analyzer with your Power BI Model to understand what is consuming memory and how to solve it.

My favourite feature in the October 2020 release of Power BI is undoubtedly dynamic M parameters. However, before I explain why, I’m going to put my hands up and admit that we screwed up the …

Two years ago, I published a survey to measure the impact of Power Query. Since then, Power BI has gained tremendous momentum and accelerated the evolution of Power Query as well. I think it's a good time to run the survey again and learn how the impact of Power Query has been changed. Please complete…

As I’m sure you’ve guessed by now I’m a big fan of dynamic M parameters in Power BI. They’re easy to use in Power BI Desktop but what if you want to use them in your own DAX…