Tag: Power BI Power Query

Solving Missing Currency Rates With Power Query In Power BI

In this tutorial, you’ll learn how to use Power Query for currency conversions in Power BI. The method discussed in this blog will help you solve problems in your currency rates table using the last available rate. You’ll understand how to work things out when the currency rates table doesn’t have a currency rate on

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

Create A Delimited List In Power Query – Query Editor Tutorial

I’m going to show you how to create a delimited list using the Power Query. I came across this question in the Enterprise DNA Forum where a member wanted to create a list of products that each distinct customer bought. This can be easily done via the Power Query. How to Create a Delimited List

Continue reading

Data Masking For Sensitive Information In Power BI

In this tutorial, you’ll learn how to perform data masking for sensitive information in Power BI using Power Query. Data masking allows you to hide or remove confidential or identifiable information in your Power BI data models. The discussion will focus on these points: And this basic model will be used as the example: When

Continue reading

Creating Values For Each Date Using Power Query Formula

In this tutorial, you’ll learn how to create values for each day using Power Query formula in Power BI. Creating values for dates is an important technique to learn in Power BI. It can give you the data you want to see throughout the days in your model. This technique also covers the gaps between

Continue reading