Tag: DAX Studio

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

Power Query Optimization: Reducing Decimal Numbers

Power Query Optimization Reducing Decimal Numbers - Enterprise DNA

In this tutorial, you’ll learn a Power Query optimization technique to reduce RAM usage. Specifically, you’ll learn how to reduce the numbers stored after a decimal place. This is helpful if you’re dealing with columns stored in a decimal number format. In this example, you can see that the Net Price is consuming 11MB of

Continue reading

Row Level Security & Object Level Security In Power BI DAX Studio

In this tutorial, you’ll learn how to test the Row Level Security (RLS) and Object Level Security (OLS) in Power BI DAX Studio. In simple terms, Row Level Security prevents user access to specified rows. Meanwhile, Object Level Security prevents user access to specified columns and tables. Examples for testing RLS and OLS in DAX

Continue reading

Using DAX To Load Data From SSAS To Power BI

Using DAX To Load Data From SSAS To Power BI - Enterprise DNA

In this tutorial, you’ll learn about the queueing capability of DAX. You’ll learn how to use it to load data from the SQL Server Analysis Services (SSAS) to Power BI. In this example, a SQL Server data model has already been created. It contains tables for the Customer, Dates, Products, and Sales data. You’ll learn

Continue reading

Power BI Measure Total Is Incorrect: How To Fix It

You might encounter issues with measures in Power BI table visualizations with a total row. The usual complaint is that the “Total” row is “incorrect” for the measure. Usually, the total row is correct for the measure, it’s just not what most people expect. In this tutorial, I’m going to take us through this common

Continue reading