Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

RLS with Multiple Reports using Shared Dataset

Hi All,   Ever since the new workspace experience went GA my team and I have been big fans of the shared dataset feature. We've been working to replace disparate reports that are replicating the...
Need Help
v-xicai's avatar
v-xicai
Community Support
6 years ago

Hi Anonymous ,

 

Currently, RLS set for one shared dataset will take effect for all the related reports.  It is not supported to set more than one security access for one shared dataset in Power BI currently. While your demand is a good idea , and you can post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner.

 

Best Regards,

Amy 

 

Community Support Team _ Amy

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hey v-xicai ,

Thanks for looking into it! Unfortunately it doesn't seem like this is possible with the current version. It would be nice if I could apply a metadata field for what app the user is currently logged into like userprincipalname(). With shared datasets I see multi-app deployments being more common. 

Alternatively, if PowerBI had column based security (like Tableau has for many years) this wouldn't be an issue. I could simply apply rules to individual columns based on role, making some "general use" and others more restrictive"

It looks like that 2nd idea already exists, I'm going to vote for that idea here