Forum Discussion
Does the data gateway allow security inheritance?
Hi mrohde,
As you are connecting to SQL Server database, Power BI service uses the credential configured under on-premise data gateway to access the SQL Server database. It means all users access the same report will see the same data, as it uses the same credential to access database. If you want to limit users to see their own data, you need to apply RLS mentioned in my original post.
Best Regards,
Qiuyun Yu
To clarify,
In the on-premise SQL 2016 server we actaully have the secrity enable. This security is working fine when we use reporting services on-premise.
What I was trying to understand is if I allow users access to the on-premise data using Power BI will the same restrictions apply in Power BI that already exist in the SQL 2016 server.
Hi mrohde,
As you are connecting to SQL Server database, Power BI service uses the credential configured under on-premise data gateway to access the SQL Server database. It means all users access the same report will see the same data, as it uses the same credential to access database. If you want to limit users to see their own data, you need to apply RLS mentioned in my original post.
Best Regards,
Qiuyun Yu