Tag: Power BI Query Editor

Organizing Your Queries Into Groups In Power BI

If you have a big data set and a large number of queries, it is a must to do data cleaning. Some users don’t realize how essential data cleanup is inside the Query Editor. You can easily use the options from the Transform ribbon or simply right-click the columns. There’s absolutely no need to use

Continue reading

Best Practices For Transforming Data In The Query Editor

When you transform your data inside the Query Editor, there are important practices that you need to implement to get the best experience. These are simple tips that can have a big impact on your reports and visualizations. It includes the things that people often take for granted but are essential in getting high-quality analysis

Continue reading

How The Query Editor Works In Power BI

For this tutorial, I’ll teach you my best practices while working on the Query Editor. This is an important feature of Power BI which, in my opinion, is under-utilized. Nowadays, they call the query editor the Power Query Editor, which is a much better name than what they initially had called it. Through the query editor, we can retrieve data from multiple

Continue reading

Creating a Dynamic Date Query Table in Power BI: A Query Editor Tutorial

One question I got from the Enterprise DNA forum revolves around an addition to the date query table. This addition prevents you from having to manually filter data to the last date every time new data comes in. This can be helpful if you’re working on an ongoing report. I’ll add a link to the

Continue reading

New Course Release – Advanced Data Transformations & Modeling

Power BI Advanced Data Transformations & Modeling Online Course

You can view details around the new course here – Advanced Data Transformations and Modeling Exciting times here at Enterprise DNA as I’m releasing yet another course into Enterprise DNA Online. The Advanced Data Transformations and Modeling course has been a work in progress for some time as I wanted to make sure that I

Continue reading