Error when refreshing dataset in Power BI Service - Useing web content for api with RelativePath

[Racuna0720]

Hi community,

I have a table with a list of address, and trying to pass an API to get geolocation, everything runs well and gets refreshed in desktop.

But when I try to refresh in Power BI Service I got an error, I have set up all data source (web and sql) as organizational.

I am using web content combined with relativepath to avoid a dynamic query issue but still not working the refreshment.

Thanks in advance,

Error in Power bi service:

[lbendlin · Accepted solution]

Welcome to the wonderful world of the formula firewall. 

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Learn

Try to keep all queries in the same partition.

[Racuna0720]

Hi Ibendlin,

After join all queries in one, the refreshment worked.

Thanks!