Tag: Power BI DAX

Using Dynamic Management Views (DMV) In DAX Studio

Using Dynamic Management Views (DMV) In DAX Studio - Enterprise DNA

In this tutorial, you’ll learn about Dynamic Management Views (DMV) in DAX Studio and how to use them to directly load datasets in Power BI. A Dynamic Management View or DMV returns server information which you can use to monitor the health of a Power BI server and diagnose any problems that may occur. This

Continue reading

Optimizing DAX For Power BI Using DAX Studio – Formula Engines

When you’re optimizing your data model and your DAX for Power BI, it helps to remember that there are two engines running behind the scenes — the formula engine and the storage engine. These two engines work together to return the results needed back to the user. They provide the results set in the form

Continue reading

Calculated Table And Column In Tabular Editor 3

Enter-Data-In-Power-BI-How-To-Use-It-For-Data-Entry

This tutorial will discuss how to create a calculated table and column in the Tabular Editor. You’ll learn how to pull out and summarize tables and columns using DAX functions. You’ll also understand why Tabular Editor is better at creating calculated tables and columns than Power BI Desktop. Creating A Calculated Column To create a

Continue reading

Best Practices For Power BI Report Development

Best Practices For Power BI Report Developme

Over the last few months, I presented several tutorials, showcasing best practices for Power BI report development for each of the four pillars of Power BI. In this blog, I wanted to take this opportunity to present my personal top 10 list. You may watch the full video of this tutorial at the bottom of

Continue reading

DAX Query In Power BI – Logical & Physical Query Plans

DAX Query In Power BI – Logical & Physical Query Plans

This tutorial will discuss about the two DAX Query Plans in Power BI. Query plans affect the DAX’s performance in generating valuable data. They also help in optimizing DAX codes that make your report more compelling. These are the two query plans that are generated by the formula engine: Every DAX query triggers these two

Continue reading