Forum Discussion

IanCockcroft's avatar
IanCockcroft
Icon for Post Patron rankPost Patron
5 years ago

Gateway refresh failing getting data from URL

Hi guys, we have a report that has a few different sources. our access system, A covid stats file on GitHub. and a few others.

The refresh has been working for almost a year, but all of a sudden, in the     last week, its been failing.

the error says it cant connect to the github file.

Running it from desktop works

every now and then the refresh works

the error ;

 

Details Type Start End Status Message

 Scheduled4/20/2021, 11:02:17 AM In progress 
 Scheduled4/20/2021, 9:02:08 AM4/20/2021, 9:27:49 AMCompleted 
Hide
On demand4/20/2021, 7:50:49 AM4/20/2021, 7:54:02 AMFailedThere was an error when processing the data in the dataset.
Data source error:{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Unable to connect to the remote server"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://raw.githubusercontent.com/CSSEGISandData/Covid-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}} Table: time_series_covid19_confirmed_global.
Cluster URI:WABI-NORTH-EUROPE-E-PRIMARY-redirect.analysis.windows.net
Activity ID:d77ab7e2-c559-4ae5-83d5-7ea4cb1e2718
Request ID:5eaf56e2-d1e8-00b4-a1ba-be59b8943373
Time:

2021-04-20 05:54:02Z

 

Any  idea whats going on   and how to fix   it?

thanks guys

ian

Need Help

4 Replies