Which all tables have OLS applied - quick check in Tabular Editor

[prasadpatil020]

Hi Community..!!

There are multiple tables and i want to check which all table has OLS into it, how can we check in one go in tabular editor ?

Coudl you please help me to do this.

Thanks in advance..!!

[MFelix · Accepted solution]

Hi @prasadpatil020 ,

Using Tabular editor you can go to the roles that you have and under each role you will see what are the tables you have with OLS:

I have to be honest using C# script not sure how this can be done, however you can use the new TMDL view on Power BI desktop and if you select the roles you will see what table and colums have the permissions:

Has you can see on each role you have the tables but also the columns that are impacted by the OLS.

[prasadpatil020 · Accepted solution]

Thank you for quick response @MFelix 

[MFelix · Accepted solution]

Hi @prasadpatil020 ,

Using Tabular editor you can go to the roles that you have and under each role you will see what are the tables you have with OLS:

I have to be honest using C# script not sure how this can be done, however you can use the new TMDL view on Power BI desktop and if you select the roles you will see what table and colums have the permissions:

Has you can see on each role you have the tables but also the columns that are impacted by the OLS.