Tag: power query advanced editor

Power BI Power Query: Removing Duplicate Rows

In this blog, I’ll show you how to remove duplicate rows in the Power BI Power Query based on conditions. You may watch the full video of this tutorial at the bottom of this blog. This example is from a question that was raised on the Enterprise DNA Forum. The member has transactional data and

Continue reading

Power Query Editor: Staging Queries

staging queries using Power Query editor

In this tutorial, we’ll learn about staging queries using Power Query editor. This is a new concept that I’d like to discuss for us to have an understanding of when and where we can use this in the query editor.   Staging queries can be used to configure and expose the data sources parameters to the dimension and fact table queries of the dataset. For Power BI datasets,

Continue reading