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
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
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
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
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
