Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

RLS with PowerBI Premium Dataset

Hi Team,

 

Imported an existing AAS Tabular cube to Power BI Premium Data set using tabular editor tool. Then after pointing the PBIX report to  the new PowerBI premium dataset i'm facing couple issue in setting RLS

 

Ability to manage roles from the report is disabled.

In AAS cube , CUSTOMDATA feature is implemented to pass  filter for User details accessing from embedded as shown below.

The same role i scripted out then ran on top Power BI premium dataset from SSMS. Now when i try to embbed the report, RLS is not working properly

 

 

Please let me know what would be correct approach to implement RLS for PowerBI premium dataset with Live connectivity from the PBIX report.

 

Thanks

Need Help

7 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi v-janeyg-msft ,

       

      The links that you have shared mainly talks about using the Dynamic FIlter criterai using CUSTOMDATA() function.

       

      There is no solution provided around PowerBI Premium dataset and RLS.

       

      Plan is to remove AAS server and leverage PowerBI premium capacity model.

       

      Please help

       

      • v-janeyg-msft's avatar
        v-janeyg-msft
        Community Support
        5 years ago

        Hi, Anonymous  Have you set the role in the report and how did you set it?