Forum Discussion

Rigensis's avatar
Rigensis
Resolver I
5 years ago

Sign in user mismatch for Google BigQuery as datasource

Hi,

 

I'm having an issue where, when selecting a google account with which to sign in to establish connection with Google BigQuery, the user that shows up when asking to give Power BI access to Google account, is not the same as previously selected.

 

How I arrive at this issue:

 

1) In 'Get Data' I choose Google BigQuery (GBQ)

2) I click on it, then the window asking to Sign In appears, Click on the 'Sign In' button

 

3) The following window opens up and I choose the green user.

 

4) After selecting the user, the next window opens up, asking to verify granting the access, but as you can see at the top a different user (same as the purple user from the previous screen) is being suggest through which the access should be granted.

 

Here I would expect to see the green user that I previously selected, not the purple user

 

 

As far as I can tell, I'm not signed in with the purple user in any of the following places:

Power BI Desktop

Power BI Service

Google Chrome

Google account

 

I've also removed access to power BI app from the purple account on the Google account side

 

Does anyone have any knowledge of how to solves this issue, or what is the correct order of operations for switching between google account for accessing GBQ ?

 

Regards,

Aivars

 

 

Need Help

5 Replies

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Rigensis ,

    Based on my test, seems could not reproduce it in my side. When I connect to Google BigQuery with the first account, it is the same with the check page:

    Perhaps you can try to clear permissions in power bi desktop and try to connect again.

    Or you can try to clear the Chrome broswer cache which stores all your google accounts.

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Rigensis's avatar
      Rigensis
      Resolver I
      5 years ago

      v-yingjl thanks for your reply! 

      I tried clearing the global permissions for GBQ connection, that did not change anything, all google accounts still showed the same.

      Also tried clearing the cache, cleared cached images, cookies and other site data, unfortunately that also did not have an effect on what google account I see in Power BI.

       

      The account that keeps showing instead of the one I'm selecting from the first window is the same with which I have logged on to my laptop, could that have any effect?

      • v-yingjl's avatar
        v-yingjl
        Community Support
        5 years ago

        Hi Rigensis ,

        Not sure. If the purple account is the account which signing in to your laptop, maybe you can use another account to sign in the laptop to check it.

         

        Best Regards,
        Community Support Team _ Yingjie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.