Unable to connect to the remote server Bing Maps

Question

Hi,

My dashboard uses longitude and latitude from bing maps. Recently, I'm facing refresh issues with the error below:

{"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":""}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Detail","detail":{"type":1,"value":""}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}}],"exceptionCulprit":1}}]} Table: LatLongAPI

Any help will be truly appreciated as I really have no idea how to resolve this. :(

Answer 1

DM_GWPipeline_Gateway_MashupDataAccessError indicates an issue with data access in the gateway used by your Power BI mashup. UnderlyingErrorCode -2147467259: This specific code points to a "Remote procedure call (RPC) failed" error, suggesting a connection problem with the Bing Maps API.

for more details you can check

https://community.fabric.microsoft.com/t5/Desktop/Help-understanding-Power-BI-error-messages/m-p/110105

Ensure your Power BI gateway can access external websites like Bing Maps. Check if any firewalls are blocking the connection. Review your Bing Maps API key in Power BI settings. Ensure it's valid and hasn't expired. top and restart the Power BI gateway service on the machine hosting it. In Power BI Desktop, right-click your Bing Maps data source and choose "Refresh."

Answer 2

Please note that the Power BI offering for the Maps Control included with Power BI is moving to Azure Maps.

Banner at https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks

If your page has converted to Azure Maps, check out https://learn.microsoft.com/en-us/azure/azure-maps/power-bi-visual-conversion?context=%2Fpower-bi%2Fcreate-reports%2Fcontext%2Fcontext

and you will want to add the Azure Maps endpoints to your firewall.