cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ndistefano Visitor
Visitor

Sensitive data security

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Sensitive data security

Hi @ndistefano ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Sensitive data security

Hi @ndistefano ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

View solution in original post

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 313 members 3,201 guests
Please welcome our newest community members: