RLS with PowerBI Premium Dataset

[Anonymous]

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

[v-janeyg-msft]

Hi, @Anonymous 

You can refer to this similar solved case to see if his solution is suitable for you:

Solved: Azure Analysis Services RLS and Embedding - Microsoft Power BI Community

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

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]

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

[Anonymous]

Its disabled  at PBIX report with PowerBI premium dataset as shown below:

So I connected to XMLA endpoint of the dataset from SSMS then i ran the script that was used to create role on the cube deployed to AAS. In that CUSTOMDATA() dynamic filter was used as part of RLS.

I'm not sure if the same functionality is supported for PowerBI premium.

Please advice.

[v-janeyg-msft]

Hi, @Anonymous 

PBI dateset function doesn't distinguish premium and shared capacity. What's the data source of your dataset and what's the connection mode? 

You need to click the button to change the connecion mode to dq.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi,

Earlier we were using AAS cube with live connection. Now i have migrate the same database to PowerBI premium dataset using the tabular editor.

From the report i'm connecting to this Power BI dataset with live connection . I cant find option to change that to DQ

[v-janeyg-msft]

Hi, @Anonymous 

If it is an LC mode dataset, it is not possible to manage the role in the desktop, and it needs to be built in the model. 

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.