Tag: power query editor

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

Appending Several Sheets In Excel To Power BI

This tutorial will discuss about how to import and open an Excel file with multiple sheets to one Power BI table. This data Excel file will be used for this tutorial. The file contains 60 sheets of data with the same layout. The objective of this tutorial is to load all the Excel sheets to

Continue reading

Power BI Column Split Power Query Tutorial: How To Split Multi-Lined Excel Cells In Power BI

Power Query Tutorial: How To Split Multi-Lined Excel Cells In Power BI

Power Platform Tutorials In this power query tutorial, I want to show you one way of splitting multiline cells into multiple rows. Sometimes you will get an Excel file where data inside the cell is split across multiple lines. Today, I want to show you how you can use Text.Split and List.Zip to help you

Continue reading

Power Query M Language Tutorial And Mastery

Power Query M Language Tutorial And Mastery

This tutorial will discuss about how to successfully implement a piece of M code and solve common errors inside the Power Query Editor. You’ll also learn how to effectively practice and master the M language in Power Query. Power Query M Language Implementation The success of implementing a piece of M code depends on how

Continue reading