Tag: power query editor

Power Query Data Types And Connectors

Power Query Data Types And Connectors

This tutorial will talk about Power Query data types and connectors. You’ll learn what data types are and see how they are compatible with each other. You’ll also learn about operators in the Power Query M Language. These will help you understand how your queries generate results and answers. The Data Types In Power Query

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 go over their uses 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

Continue reading

Format Data In Power BI: Addressing Irregular Data Formats

Format Data In Power BI- Addressing Irregular Data Formats

In today’s blog post, we’ll discuss Problem of the Week #6. I’ll show you how to format data in Power BI involving the use of power query. The screenshot below is the solution that you should have after you’ve done all the data transformation. The actual balance number was $685,616.33. You can watch the full

Continue reading

Data Granularity Issues In Power BI

Data Granularity Issues In Power BI

For today’s blog post, I’ll come up with a solution that will address data granularity issues. At Enterprise DNA, we are believers of getting your hands dirty. Our ongoing series, Problem of the Week, is all geared towards putting what you’ve learned into practice. We don’t think there’s a faster way to learn Power BI

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