Forum Discussion
RLS with PowerBI Premium Dataset
Hi, Anonymous Have you set the role in the report and how did you set it?
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.
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.
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
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.