Tag: Tabular Editor 3

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

How To Install DAX Studio & Tabular Editor In Power BI

INSTALLING DAX STUDIO

In this tutorial, you’ll learn how to download and install DAX Studio and Tabular Editor 3 in your computer, and how to configure them for use in Power BI and in Excel. This demonstration includes a detailed step-by-step instruction. Some points to remember are also included to ensure that you have a seamless experience when

Continue reading

Power BI And SSAS – Sorting Columns Using TE3 & C#

For today’s tutorial, I’m going to show how you can automate the process of sorting one column by another column inside Power BI and SSAS or SQL server analysis services. You can watch the full video of this tutorial at the bottom of this blog. In this example, we have the Dates table with several

Continue reading

Matrix In Power BI Using Calculation Groups

This tutorial will talk about calculation groups and how to implement them in a matrix using the Tabular Editor in Power BI. You’ll learn how to efficiently retrieve and show data in your reports. Creating A Matrix In Power BI Calculation groups can be used to selectively show a measure in a matrix or any

Continue reading

DAX Coding Inside Tabular Editor 3

This tutorial will talk about DAX coding in Tabular Editor 3. You’ll learn how to create DAX queries and understand how it can be used as a query language. You’ll also learn how to utilize and maximize queries to obtain certain data from large tables. DAX Coding For Local Sessions Within A Query Tabular Editor

Continue reading