Forum Discussion
Data refesh nor working
Power BI service refresh is giving me an error. Working with power BI desktop refresh works, then I upload to service, and refresh works fo ne day and thn crashed. Why is that? I dont eget the error:
Data source error: [ValidateMarkupTags]{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"[ccon]-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"[ccon]Funkcja Web.Contents cannot get content from „https://sheets.googleapis.com/v4/spreadsheets/xxxxx-M?fields=sheets/properties,namedRanges” (502): Bad Gateway[/ccon][/ccon]"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"GoogleSheets"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"[ccon]://docs.google.com/spreadsheets/d/xxxxxxx-M/edit?usp=sharing[/ccon ]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Url","detail":{"type":1,"value":"[ccon]://sheets.googleapis.com/v4/spreadsheets/xxxxxxxxxxx-M?fields=sheets/properties,namedRanges[/cc... ]"}}],"exceptionCulprit":1}}} Table: Goals.
2 Replies
Hi Anonymous -The error you are encountering during the refresh of your Power BI report in the service, but not in the desktop, seems to stem from the Google Sheets data source you are using.
The error message indicates that Power BI's Web.Contents function is unable to fetch content from Google Sheets via the API URL (https://sheets.googleapis.com/v4/spreadsheets/...) due to a 502 Bad Gateway error. This is a common error that occurs when there is an issue with the server communication between Power BI and Google Sheets.
Monitor your API quota usage in the Google Cloud Console and consider adjusting the refresh frequency to avoid hitting these limits.
Reauthenticate your Google Sheets data source in Power BI Service by updating the credentials.
Re-authenticate the Google Sheets data source: Go to Settings > Datasets > Select the dataset > Data Source Credentials > Reauthenticate.
Check Google Sheets API usage: Monitor the API rate limits in your Google Cloud Console.
sort the above mentioned points, hope it helps.
