Tag: power query editor

A Quick Overview On Different Power Query Tools In Power BI

A Quick Overview On Different Power Query Tools In Power BI - Enterprise DNA

Power Query is a powerful tool in data transformation. After understanding about the ribbons and panes found in the Query Editor, the next step is getting acquainted with its various features. In this tutorial, we’ll go over a quick overview on the different Power Query Editor tools that’ll assist you in organizing your data. Power

Continue reading

What Is Power Query & M Language: A Detailed Overview

What Is Power Query & M Language A Detailed Overview - Enterprise DNA

In this tutorial, you’ll learn about Power Query and the M language inside the Power BI desktop. Although there can be slight differences, you can apply the same general techniques across other Microsoft products like Excel, Analysis Services, and other Microsoft tools with an embedded Power Query Engine. What Is Power Query? Power Query is

Continue reading

Power Query: How To Quickly Add Notes

Power Query How To Quickly Add Notes - Enterprise DNA

In this post, we’ll learn different ways to add notes in Power Query, which can benefit the people who do not like to take notes. You can watch the full video of this tutorial at the bottom of this blog. Adding Notes In Power Query: Step Properties The first and easiest one is the feature they

Continue reading

Power Query Best Practices For Your Data Model

BEST PRACTICES FOR DATA MODEL

Power Query is used to prepare each of the tables loaded into the data model. Hence, it’s fundamental that the tables, fields, and measures in the data model should be uncomplicated and user-friendly. In this tutorial, let’s talk about some Power Query best practices for our data model, some of its features, and why we

Continue reading

Microsoft Power Query Tutorial On How To Fix Mixed Fixed Column Width Issues

Mudassir: For today, we have a very interesting problem to work with. The problem with this file is that it is fixed delimited by columns and I don’t know how to resolve this using Microsoft Power Query. You can watch the full video of this tutorial at the bottom of this blog. First, it wasn’t

Continue reading