Refresh data from an intranet REST api

[Kurren]

I want to refresh a report on the Power BI service which gets data from a REST api held on the intranet using

Json.Document(Web.Contents(intranetUrl))

Even if I install a gateway on the server, the Power BI service tries to directly make the rest call to the intranet url, so it fails. Is there a way to force this to be refreshed via the gateway?

Thanks

[Anonymous]

Hi @Kurren 

Did you create the report in Power BI Desktop ? Which connector you used to connect to the data source ?

Best Regards,
Community Support Team _ Ailsa Tao

[Kurren]

Hi @Anonymous 

Yes, the report was created in power BI desktop. There is no connector, I am using the above code snippet directly in power query. It works because my desktop is connected to the intranet, but it doesn't work from power BI service. I have the gateway installed on my desktop but it makes no difference, as the gateway is not being used to make the REST api call.