Tag: Power BI Power Query

Power Query Features: An Overview

Power Query Features: An Overview

This tutorial will discuss about the available features inside the Power Query Editor. You’ll learn how to access and maximize these features in order to improve your data development skills in Power BI. You’ll also learn how these power query features will help you build data reports more efficiently. The Advanced Power Query Editor And

Continue reading

Power Query Tools, Tabs, And User Interface

Power Query Tools, Tabs, And User Interface

This tutorial will discuss about Power Query tools and ribbons. You’ll learn how to be efficient in data modeling and will know your way around the editor. You’ll also learn about the different tabs, ribbons, and context menus and how they can help you achieve the perfect Power BI data report. Power Query Tools And

Continue reading

M Language and Power Query Editor In Power BI

_M-Language-and-Power-Query-Editor-In-Power-BI

In this tutorial, you’ll learn about Power Query and M language and how to master them. This will also discuss their use inside the Power BI desktop. You’ll learn and understand their importance in developing and obtaining data for your Power BI reports. The Power Query Editor Power Query is designed for data transformation and

Continue reading

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. You may watch the full video of this tutorial at the bottom of this blog. 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

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