PBI Services: The remote name could not be resolved

[bert88]

Since last week on a lot of datasets we're getting the following error: 'The remote name could not be resolved'. 

Datasets have a combination of SQL, dataflows and sharepoint sources. The on-prem sources are connected through on-prem gateway. 

Tried changing the sharepoint sources by adding them through gateway, which looked to be the solution but unfortunately still getting the error. 

Any suggestions to resolve this issue?

Example:

{"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":"The remote name could not be resolved: 'api.powerbi.com'"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":"https://api.powerbi.com/powerbi/globalservice/v201606/clusterdetails"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}}
URI cluster: WABI-NORTH-EUROPE-I-PRIMARY-redirect.analysis.windows.net
Activiteits-id: 86853c28-a2f2-4854-9f45-fa19db0ff8f9
Aanvraag-id: 0b84c78b-fbe8-2123-d6d0-2572785402c9
Tijd: 2022-12-05 10:02:14Z

[joanwanjiru]

Did you ever find a solution to this?

[bert88]

Still struggeling with the errors. Currently trying to reconfigure the gateway with our admin.

[v-tangjie-msft · Accepted solution]

Hi @bert88 ,

It appears to be receiving the effects of a gateway down.
You can try
1. Clear permissions in the data source settings and reconfigure the gateway data source.
2. Install the latest version of the gateway.

Please refer to the following post that may be helpful to you:

Solved: Dataflow refresh Failed AzureBlobs failed to get t... - Microsoft Power BI Community

Best Regards,

Neeko Tang

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