Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Google Sheets Auto refresh in Power BI Report

Dear Power BI users,   I am using Power BI desktop to generate data visualization for the data from Excel files and Google sheets. For reading in google sheets, I am using the Beta version, that is...
Dataflow
Need Help
  • v-zhangti's avatar
    v-zhangti
    4 years ago

    Hi, Anonymous 

     

    The situation you mentioned does exist. This is a known issue, ICM is 285035360. While doing OAuth2 authentication, GoogleSheets connector was not receiving refresh token due to which once Access token expires(after one hour), there is no way for for GoogleSheets report to refresh and get new access token.

     

    Also, based on my testing, you can currently try the Web connector to connect Google Sheets, please refer to https://www.youtube.com/watch?v=Z9V221eNbi0. 

    Then use standard gateway to connect to the data source and it will not have invalid credentials as frequently as the google sheet connector.

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more.

     

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, Anonymous 

 

The situation you mentioned does exist. This is a known issue, ICM is 285035360. While doing OAuth2 authentication, GoogleSheets connector was not receiving refresh token due to which once Access token expires(after one hour), there is no way for for GoogleSheets report to refresh and get new access token.

 

Also, based on my testing, you can currently try the Web connector to connect Google Sheets, please refer to https://www.youtube.com/watch?v=Z9V221eNbi0. 

Then use standard gateway to connect to the data source and it will not have invalid credentials as frequently as the google sheet connector.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more.

 

sebaschur79's avatar
sebaschur79
New Member
4 years ago

Hi, I understand from your captures that you are connecting to an open sheet available to be read by anyone with the link. Do you know if this would work with protected sheets that need a login from specific users?