Mike Allen's Blog - Doing Smarter Things With IT - I’m going to show you how to calculate primes in Excel using Power Query and the Sieve of Erat

There were a lot of exciting announcements at the Microsoft Business Applications Summit this week but if you only watched the keynotes or read the recap on the Power BI blog you will have missed a…

When you use a parameter as the url in a web query, the data source is a Dynamic Data Source and will not refresh in the Power BI service.

The Query Plan visual will allow you to understand what’s happening under the hood of your query with more details than the Step Folding indicator.

Today we are excited to announce the initial availability of Power BI connected PivotTables in Excel for the web. As part of our journey to simplify enterprise data discovery and analysis in Excel, …

This is the first post in a series to create a Star Wars report. This post handles the issue of using a parameter as the url in a web Power Query. This type of data source is referred to as a Dynamic …

How to measure the duration of a Power BI DirectQuery query using Performance Analyzer

For a while now, I have been wanting to have the capability in Power Query to select a query by name PROGRAMMATICALLY. Why? Building a SelectQuery Function would allow me to execute one of multiple “Transform” queries depending on a user selection on the Excel sheet. This will help me process log fil

A lot of us work with Power Query Editor in Power BI and are familiar with its different capabilities that it provides to a report developer. I was recently approached by one of my colleagues who has started learning Power BI, to check if there is a way to implement CONTAINS functionality on a TEXT ...

Learn about how you can set up dataflow automation using the Power Query Dataflows connector in Power Automate!

Hi Power BI Folks! Welcome to our 2nd post here at daxproservices.com.Today, I wanted to share some thoughts about how to keep the house clean when naming the transformation steps of your Power Query …

The low-code capabilities of Power Query can be leveraged to solve highly complex data challenges. I have recently developed a data quality automation solution with it, that takes data quality to the next level. What is the point in purchasing an expensive shelf-product that implements an enterprise data quality automation suite, when you can build…

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

Foreword from Imke: Pat Mahoney is a very active fellow super user in the Power BI community and has a very strong interest in all things Power Query. He also (…) Read more

Some interesting new Power Query functionality was released in the December release of Power BI Desktop (it’s also in the build of Excel I’m running) that didn’t get announced in …

I tend to create tables using M or a combination of point-and-click and M, because these tables are treated as base tables if the model is refreshed and for this reason these tables will benefit from all the compression magic, whereas tables created using DAX are not that well compressed.

Query folding is a key capability in Power Query. In short, query folding is the process by which the Power Query mashup engine takes the steps defined in the Power Query editor and translates them…

AI Insights in Power Query is a great Premium feature in Power BI. AI Insights Error can occur if you are not fully aware of the settings.

We’re pleased to share that we are now previewing step folding indicators in Power Query Online. These indicators will allow you to understand which steps fold, and which steps don’t. Read on for more.

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…

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…

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 …

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

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

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