Forum Discussion
Advocate IIConnection to Google Sheets from Powerbi - anyone else experiencing an error message?
Advocate IIHi Xiaoxin, Thanks for that.
However, my question is more about if anyone who has been using Google Sheets as a data source (using the web connector) is experiencing issues with this connection. My experience is that this was previously entirely stable but now returns an error message - despite no changes in permissions. Curiously the data loads correctly after this and also loads on automatic refreshes. Whilst I'm glad that it's loading I am concerned that this may cause errors in the future.
HI JonSwed,
The data structure break issue I mentioned above can be caused by network status.
>>Whilst I'm glad that it's loading I am concerned that this may cause errors in the future.
Normally, they will work well. (if google API or power bi service releases new features or changes in data structure/authorizations, you need to check your reports and correspond datasets)
In addition, you can also enable the notice of refresh failed to help you trace the dataset status.
Sending refresh notifications to others | Microsoft Power BI Blog | Microsoft Power BI
Regards,
Xiaoxin Sheng