Forum Discussion
RLS to Modeled Dataset in Power BI Service
Community SupportHi Anonymous
It seems impossible currently.
When using RLS with app workspaces in Power BI, If you publish your Power BI Desktop report to an app workspace within the Power BI service, the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the app workspace settings.
But for anyone who could download a pbix copy from Power BI Service, he must have edit access to the report.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-juanli-msft,
Thanks for clarifying this. Is there a known or possible workaround to what I'm trying to achieve? The end goal is just for the report creators to connect to a modeled/ transformed data in Power BI (without accessing the original source, for example, a SQL database) and still have restrictions in the data?
What I'm thinking for a possible workaround (although the method is quite brute and might not be recommended) is
- I can create a single pbix with all that transformations in it. Then parametrize branch Id to make the query dynamic.
- Publish the pbix for each branch Id into different workspaces.
- This way, the members of the workspace who can only view the data for their branch can create a report by using Power BI Dataset in Get Data.
The catch here though is, I have a lot of branches. Can you recommend other possible ways to address this? Many thanks!