fluf1024 / pqgooglespreadsheet Goto Github PK

OAuth will time out between refreshes. After about an hour (or less) it will prompt you to sign in again. Error message is in the image below. Once you sign-in and connect everything is fine. And you can refresh again without connecting. But once idle it will give the error again and you have to sign in again.

I followed the instructions, unzipped the file, edited the client ID and password key, zipped it up again, renamed the file etc but I get an error message on use:
[Expression.Error] We couldn't find the file 'client_id.txt'.
Also the icon doesn't appear next to the name in the menu.
Do you know why this might be?

Personal Gateway should now allow you to schedule this to refresh, however I'm getting an error...

Thanks for this awesome connector!
Managed to make it work if I replaced the reference to the client_id.txt and client_secret.txt by hardcoded values, but would prefer to handle them as variables instead. Where am I supposed to put the files in order to make this work?

Hi! When I went to refresh data in PowerBI, I got this error:

I haven't gotten this error before, including when I had successfully refreshed this data set as recently as about 2 weeks ago. This error message does not include a button to bypass the error and connect anyway.

Any ideas?