Achieving data security in Self Service in Power BI

[RacAgr]

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.

[v-jiascu-msft]

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

[TomMartens]

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?

[RacAgr]

MS 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