Tag: Storage Engine

Evaluate DAX Code Performance In DAX Studio

Evaluate DAX Code Performance Using The Run Benchmark Option In DAX Studio - Enterprise DNA

In this tutorial, you’ll learn how to evaluate a DAX code’s performance using the Run Benchmark option in DAX Studio. The Run Benchmark option allows you to customize the number of cold and warm cache executions in your query. When you click this option, the Benchmark wizard opens. You can specify the number of times

Continue reading

Query Plan & Server Timings In DAX Studio

Query Plan & Server Timings In DAX Studio - Enterprise DNA

In this tutorial, you’ll learn about Query Plan and Server Timings in DAX Studio. This is an overview of what happens behind the scenes whenever you run a DAX query. You can find the Query Plan and Server Timings option in the Traces pane under the Home tab. Query Plan In DAX Studio When you

Continue reading

Data Cache: What It Is And How It Helps To Optimize Queries

Data Cache What It Is And How It Helps Optimize Queries - Enterprise DNA

In this tutorial, you’ll learn what a data cache is and why it’s important. A data cache stores bits of data that could become valuable for future use. If you need the same pieces of information in a future measure or action, the data cache will provide the information you need. It eliminates making the

Continue reading

DAX Query In Power BI: Understanding Its Logical Flow

DAX Query In Power BI Understanding Its Logical Flow - Enterprise DNA

In this tutorial, you’ll learn how a DAX query is executed in Power BI DAX Studio. This tutorial presents two flowcharts. The first flowchart shows the basic process behind an execution of a DAX query. Meanwhile, the second flowchart gives a distinct example to better visualize the process. Flowchart Of A DAX Query In Power

Continue reading

Storage Engine – Its Role In Optimizing DAX Queries in Power BI

In this tutorial, we’re going to take a look at the second engine inside analysis services — the storage engine. We discussed the top-level engine, the formula engine, in a past tutorial. When users understand how both these engines work, it’s easier to optimize and improve the performance of your DAX queries. The storage engine’s

Continue reading