Tag: power query editor

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 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

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 out in a

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

Power Query Power BI | Create New Records Based On Date Fields

Power Query Power BI | Create New Records Based On Date Fields

For this tutorial, I want to showcase a couple methods on how you can create new records based on date fields using Power Query Power BI. You can watch the full video of this tutorial at the bottom of this blog. I’m going to showcase two methods on how to achieve this. This example came

Continue reading

Power Query Language Flow Best Practices

Power Query Language Flow Best Practices

In this tutorial, you’ll learn about the Power Query Language Flow and some of its best practices. You’ll also learn how to transform your data easily to get the best possible results. Data transformations will optimize your report and make it look compelling. Set Data Types With No Power Query Language Flow The bare minimum

Continue reading