Tag: Power BI Query

Extracting A Query Result In DAX Studio Using The Output Option

Extracting A Query Result In DAX Studio Using The Output Option - Enterprise DNA

In this tutorial, you’ll learn how to extract a query result from measures and tables in DAX Studio, and transform them into a text or Excel file. In this example, this basic measure will be used: When you run this measure, you’ll see that the results show a table comprised of two columns. The first

Continue reading

Overview Of The Query Editor User Interface In Power BI

Overview Of The Query Editor User Interface In Power BI - Enterprise DNA

The Query Editor in Power BI is designed to help the user apply most of the common transformations by interacting with a set of ribbons and menus. In this tutorial, you’ll learn how the query editor is organized. Knowing your way around the user interface will help you become more efficient. The Query Editor In

Continue reading

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