Category: Power Query in Power BI

Improve Power BI Refresh Time & Performance

Improve Power BI Refresh Time & Performance - Enterprise DNA

In this tutorial, you’ll learn how to reference tables in Power Query to improve refresh time and data performance in Power BI. You can watch the full video of this tutorial at the bottom of this blog. Power Query has an option to set the refresh frequency for a query by selecting the “Refresh every”

Continue reading

COALESCE Operator: Power Query Application

COALESCE Operator Power Query Application Enterprise DNA

This tutorial will demonstrate how to use the COALESCE operator in Power Query / M language by examining two practical problems. You can watch the full video of this tutorial at the bottom of this blog. The COALESCE operator is represented by a double question mark (??). This operator works similarly to the or operator

Continue reading

Introducing Power Query Extended Date Table V2

Introducing Power Query Extended Date Table V2 - Enterprise DNA

In today’s blog, I will briefly introduce the Extended Date Table 2.0. I first shared the code for this M function in April 2020. Since then, there have been a number of requests and updates on this Power Query date table. You can watch the full video of this tutorial at the bottom of this

Continue reading

Power Query Each Expression: An Introduction

Power Query Each Expression An Introduction - Enterprise DNA

Power Query is a data transformation and manipulation tool that’s available in Microsoft Excel and Power BI. It has a wide range of functions that can be used to transform and manipulate data. In this tutorial, you’ll learn how to use the each expression in Power Query / M Language. You can watch the full

Continue reading