Posts filed under Power BI Features

Testing Your Code Using the [DAX] Query View!

Video by: Reid Havens

See some examples on how to leverage the DAX query view to save some of your test code, and staging tables. A great improvement from having to save hidden test and development report pages in your PBIX file. Tune in to learn more!

RELATED CONTENT πŸ”—

Jeffrey Wang Livestream
Working with DAX Query View

Download Report From The Blog Files Page
Posted on February 6, 2024 and filed under DAX, Power BI Features.

(Livestream Replay) DAX Query View Best Practices & Historical Context - with Jeffrey Wang

DESCRIPTION πŸ“„

The November Desktop release's public preview of the DAX Query View has ignited excitement among the DAX community. This feature represents the first new view since the inception of Desktop, joining the existing trio of Report View, Data View, and Model View. This addition is poised to transform the way DAX programmers approach their craft, encouraging them to write their own DAX queries more frequently.

A common challenge with DAX lies in its flexibility, as multiple methods often exist to achieve similar results. DAX queries are no exception; the community has already begun discussing various functions capable of producing comparable query results. In this episode, we will delve into the recommended functions and patterns for writing DAX queries. We aim to demystify the best practices recommended by the product team by exploring the historical context of their development.

GUEST BIO πŸ‘€

Jeffrey has over twenty years of experience in the BI industry and joined the Microsoft SQL Server Analysis Services team in 2004. As a co-inventor of the DAX programming language, Jeffrey has watched it grow from an unknown language to one that is widely used worldwide. His latest projects in DAX include the development of the recently announced Visual Calculations.

RELATED CONTENT πŸ”—

LinkedIn
Blog

Download ZIP From The Blog Files Page
Posted on December 29, 2023 and filed under Livestreams, DAX, Power BI Features, Power BI.

Three Techniques for Curating the User Experience in Power BI!

Video by: Reid Havens

Learn about three primary techniques for simplifying and curating the user experience for reports in Power BI. There's a mixture of art and science that goes into smart report design, especially designs that minimize pop-ups, distractions, and user interactions. Tune in to learn more!

RELATED CONTENT πŸ”—

PowerBI.Tips Theme Generator
Theme Generator (Livestream)
PBI Explorer
PBI Explorer (Livestream)
Dynamic Analytics Line

Download Report From The Blog Files Page

Extracting SQL Database/Table Names From Your Power BI Dataset!

Video by: Reid Havens

Learn how to query the XMLA end-point in a Premium (Per User or Capacity) workspace to extract all the Power Query M Code, and parse out your SQL Database names, table, names, and parameters from your queries. Tune in to learn more.

RELATED CONTENT πŸ”—

Extracting All M-Code from a Power BI Dataset

Download Report From The Blog Files Page