Tag: Power BI Query

Power Query Editor Tutorial: Extract Record Field Values From Lists

Power Query Editor Tutorial: Extract Record Field Values From Lists

In this Power Query Editor tutorial, I want to showcase how you can extract record field values from a nested list and combine those into a single text string. You can watch the full video of this tutorial at the bottom of this blog. A member of the Enterprise DNA Forum posted this scenario. We

Continue reading

Using The M Function To Create An Extended Power BI Date Table

This tutorial will cover about the most important Power BI dimension table in any model, the Date Table. You may watch the full video of this tutorial at the bottom of this blog. The best practice when designing a model is to check for date fields. If they are present, always include a date dimension

Continue reading

How Query Dependencies Work In Power BI

Query Dependencies In Power BI

Power BI SQL Query For this tutorial, we are going to delve deeper and understand how Query Dependencies work in Power BI. Query Dependencies show you how the queries are linked together inside Power BI. You can see which queries depend on other queries or tables. This is useful when you plan to do a

Continue reading

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

Row And Column Transformations In Power BI

I want to go over some of the best practices in optimizing your rows and columns inside the Query Editor. You can optimize your table so that when you create visualizations, you’ll be able to recognize your columns easily. One of the best ways to develop the most intuitive Power BI model is to simplify

Continue reading