Credentials for Google Sheets connector

[Varian]

In the beta version of Nov, I change my report datasource to Google sheet, and enable the schedule refresh.

But I find the credentials always expired manybe after 1hour, and I need to edit the credentials again and again.

[DavidPROVOST]

Initially, Google sheets connector could only connect to anonymous files.

At the end of 2021, it worked fine on sheets with restricted permissions (OAuth2). During january, there has been an issue with OAuth2 refresh token. which has been fixed meanwhile. Now, everything works fine.

[DavidPROVOST]

I have the same problem here, Still not resolved. Or should I re-publish from the Last version of desktop ? As for the propose solution, are cant figure out how to set google credentials for datasource ?

[Anonymous]

I think this issue has been resolved. My report works just fine.

[sebaschur79]

Hi, are you connecting to a protected sheet that needs a login from specific users? or an open sheet available to be read by anyone with the link?

[v-kkf-msft · Accepted solution]

Hi @Varian ,

The situation you mentioned does exist. This is a known issue, ICM is 274490819. 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. This makes report fail after one hour. I will follow up on this issue in this post.

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.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

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