Tag: power bi query folding

Data Loading And Transformation Best Practices

Data Loading And Transformation Best Practices

I’d like to present the best practices I’ve adopted while preparing Power BI reports. Over the past few years, I’ve consumed many online resources on data loading and transformation which have been instrumental in my journey, but I quickly became overwhelmed by the content, so I ended up making my own notes. You can watch

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