Forum Discussion
Connecting to a local API via data gateway
Well, that's not really "local". How are you planning to do development work? Running Power BI Desktop on a VM that is in the same subnet?
Ok - that sounds reasonable - how do I do that?
go to Power Platform admin center (microsoft.com) and add a new Web connection with the base URL.
Ok - I've done this in the admin center. It's showing as status Online but still getting the same "unable to connect to remote server" error in PowerBI.
Do you have the April 2023 version of Power BI Desktop?
Yep -
There were some comments on the interwebs that that might be buggy. Try reverting to the March version.
Re: DataSource.Error: Web.Contents failed to get c... - Microsoft Power BI Community
Still the same unfortunately. Even with the March version
Are you able to consume that API from your PC via other means? Like, through a browser or wget or curl ?
No - it is on a VM in azure - only accessible via the data gateway.
Well, that's not really "local". How are you planning to do development work? Running Power BI Desktop on a VM that is in the same subnet?
Ah, so it's not possible for PowerBI desktop to use the data gateway directly?
What if I create a custom connector? Use custom data connectors with the on-premises data gateway - Power BI | Microsoft LearnStill no. Power BI Desktop must have direct line of sight to the on-premise data sources.
Ok , thanks - I've managed to get access directly and it's all working as expected!