Gateway refresh failing getting data from URL

[IanCockcroft]

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

	Scheduled	4/20/2021, 11:02:17 AM		In progress
	Scheduled	4/20/2021, 9:02:08 AM	4/20/2021, 9:27:49 AM	Completed
Hide	On demand	4/20/2021, 7:50:49 AM	4/20/2021, 7:54:02 AM	Failed	There 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_ti...}}} 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

[Anonymous]

Hi @IanCockcroft ,

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it.

Best Regards,
Eyelyn Qin

[Anonymous]

Hi @IanCockcroft ,

As the official document said, You should always ensure that basic requirements for refresh are met and verified. These basic requirements include:

• Verify the gateway version is up to date
• Verify the report has a gateway selected - if not, the datasource may have changed or might be missing.

In addition, please also try #fiddler-trace to find out the exact reason. 

Refer to:

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

https://community.powerbi.com/t5/Developer/Unable-to-connect-to-the-remote-server-app-powerbi-com-po...

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[aj1973]

Hi @IanCockcroft 

If it's been working for a year and stoped plus if the Desktop can still do the refresh then you need to update your Gateway and/or check out the Gateway.

[NimaiAhluwalia]

Hello @IanCockcroft 

By looking at the error the problem is from the source.

Try configuring the gateway again or re-publish the report to the service, you can also try to open a support ticket for free if you are PRO user!

IF MY SOLUTION HELPED YOU PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT SOLVES YOUR ERROR!