Forum Discussion
Google Big Query connection credentials
Hi, Anonymous ;
where are you implementing the RLS? In bigquery or power bi report?
https://cloud.google.com/bigquery/docs/row-level-security-intro
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Yalan,
The RLS is implemented in BQ. The RLS is also not the issue, this is working properly. The issue is the way Power BI service handles credentials for Big Query. This seems to be on 'tenant' or 'account' level. So changing the data source credentials for one dataset also changes it for another. We are now solving it by creating multiple pro accounts for different reports, but I find it strange and inconsistent to other data source behavior that we can't specify details on a dataset level.