Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
we are setting a new PBI environment for a client and we are a facing a security problem.
In the target architecture there will be an application management team that will be able to check, edit and deploy new or old reports in this environment.
They will be able to make changes with PBI desktop with a dev source (a copy of the production one) and after that they will be able to publish in the organizational workspace.
The issue is that they MUST not have the access to the production source but if they can publish on a workspace they will be able to download and view production data, how can we manage that?
Thank you so much
Solved! Go to Solution.
Hi @Anonymous ,
I'd like to suggest you to add RLS on your datasource and parametrized your connection with query parameters.
Deep Dive into Query Parameters and Power BI Templates
RLS with UserName()
After these steps, you can change datasource on power bi service side and assign correspond roles to control viewed contents.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Notice: RLS not works for edit permission users.
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
I'd like to suggest you to add RLS on your datasource and parametrized your connection with query parameters.
Deep Dive into Query Parameters and Power BI Templates
RLS with UserName()
After these steps, you can change datasource on power bi service side and assign correspond roles to control viewed contents.
Using the Power BI Service Parameters to change connection strings (To possibly change between Dev
Notice: RLS not works for edit permission users.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.