Forum Discussion

Luchiuda's avatar
Luchiuda
New Member
2 years ago
Solved

Power BI Dataset Refresh Error with Google Sheet

I have several Power BI dashboards that use Google Sheets as a data source, that are configured to automatically refresh every day.  After 2 days of publishing the report, there is always an error w...
Need Help
Luchiuda's avatar
Luchiuda
New Member
2 years ago

Hi v-zhangti ,

Thanks for your reply. I do not have a on-premises gateway that works 24/7, and either way, my dataset only contains cloud data sources. This is why I established a scheduled refresh of the dataset without using an on-prem.
That solution was working correctly with all my reports. However, lately I have been having credentials issues when refreshing the dataset. The thing that comes to my attention is that each day I have issue with a different report, I can’t find a pattern. Some days I have to renew the credentials of 2 google sheets of a report, the next day 1 sheet of another report, and so on.
Do you have another solution for my problem?
Thanks!