Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to filter a (Power Query) table using a calculated Measure?

I have a table: Department that has columns [DepartmentName], [Domain], etc. I have a Measure 'Department'[Measure_UserDomain], which uses the DAX function USERPRINCIPALNAME() with some text extracti...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Anonymous 

    1. Power BI has 2 languages - M (Power Query Scripting) and DAX. 

    2. Power Query loads tables - think of it as an ETL process, while DAX can be ETL also (Calculated Tables and Calculated Columns) but also is the report run-time language of Power BI. Therefore, you must count on DAX, and not M, to do the Row-Level Security.

    3. How to solve this issue? Create a Role, and apply the row-level security on there with your DAX. On the Department table,  [Domain] = <your text extraction on USERPRINCIPALNAME()>

    Cheers!

    Nathan

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous 

1. Power BI has 2 languages - M (Power Query Scripting) and DAX. 

2. Power Query loads tables - think of it as an ETL process, while DAX can be ETL also (Calculated Tables and Calculated Columns) but also is the report run-time language of Power BI. Therefore, you must count on DAX, and not M, to do the Row-Level Security.

3. How to solve this issue? Create a Role, and apply the row-level security on there with your DAX. On the Department table,  [Domain] = <your text extraction on USERPRINCIPALNAME()>

Cheers!

Nathan