Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Passthrough Authentication for Google BigQuery?

Hi,   first of all I would like to mention that I'm new to Power BI, as User, Devloper and Admin and in the beginning phase of a project. My work experience is based on MicroStrategy, please excuse...
Data Protection
Need Help
ggbae's avatar
ggbae
Frequent Visitor
4 years ago

Hi,

 

Were you able to find a solution to this? I have similar issue where I am using view to enforce row-level access based on the current user in bigquery and for it to work, I need a feature where end users will use their credentials in power bi service.

 

Also, where are you implementing the RLS? In bigquery or power bi report?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi,

 

unfortunatley not, we use the workaround with the Service Account through the Gateway for now. (see my response from ‎05-11-2022)

Please note that in the meantime Microsoft released a bug during the process of adding Service Account Credentials to a BigQuery Datasource: 

https://community.powerbi.com/t5/Issues/Accountkey-limited-to-200-characters-in-the-new-interface-of-the/idi-p/2510767

 

We are still in the beginning of our Power BI setup, we just got Admin rights to our own capacity but requested external help as I only have experience as MicroStrategy Admin.

Right now we can split our users in just two groups and separate the access with two Workspaces.

We also would like to use our Authorized Views as intended but can't, as we have to work with the SA-workaround. I currently see no chance using BigQuerys RLS capabilities 😕 

With an increasing amount of reports we will have to implement RLS in Power BI.

 

If you or anybody else can help, please ping me too 😉