Forum Discussion
Helper IAchieving data security in Self Service in Power BI
How to achieve data security restrictions during self-service implementation in power BI so that when the user (user1) connects to DB in power BI desktop, it gets the restricted data only. (data visible to him will be only related to user1)
Could you please help us with it.
4 Replies
- TomMartens
Super User
Hey,
maybe this whitepaper will help you a lot:
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-power-bi-security/
Can you please reveal what database you are using?
RacAgrMS Azure sql datawarehouse
- TomMartens
Hey,
maybe this article provides the necessary input:
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
Hope this helps
v-jiascu-msftMicrosoft Employee
Hi RacAgr,
Power BI Desktop connects to DBs with the user credential of that DB. All the source that the user have access will show up. So we need to restrict the access in the DB. We could create different roles or different schema and grant to users or roles properly. I would like to suggest you go to Forums/sqlserver for more professional advices. Maybe you could refer to these documents.
grant-schema-permissions-transact-sql
ownership-and-user-schema-separation-in-sql-server
sql-data-warehouse-develop-user-defined-schemas
https://azure.microsoft.com/en-us/support/forums/
Best Regards!
Dale
