Underlying error code: -2147467259 Underlying error message: Unable to connect to the remote server

[DaGemsta]

I'm getting this for a web lookup I'm using on all of my reports. This happens most of the time on scheduled refresh but is fine if you check it manually.

We use an on-prem gateway and I can access it from that machine without error manually.

Underlying error code: -2147467259
Underlying error message: Unable to connect to the remote server
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.Detail: http://vip.timezonedb.com/v2.1/list-time-zone?key=3QO11C5TE426&format=xml&country=GB&zone=Europe/Lon...
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Cluster URI: WABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID: e0b166cd-9ed9-4b6c-b4c8-21a8312779a7
Request ID: 1926e533-1ab5-4378-8d8e-3cd14e33a655
Time: 2023-01-17 15:18:54Z

Help please! It's making all of reports fail their scheduled refresh 😞

[v-yetao1-msft]

Hi @DaGemsta 

It's a known issue . The engineers are working hard on this issue and I will come back with an update if there is any progress. 

Best Regards,
Community Support Team _ Ailsa Tao

[Noe82]

Hello,

Is there any progress on this error? I have uninstalled the gateway and reinstalled and the error persists.

I have updated the gateway to the new version and the error persists.

Can you provide me with the solution?

[Tamuna]

I have the same problem, Is there any solution?

[Noe82]

Hello

I modified the measurements using variables and it seems to work.