Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Formula.Firewall error; calling a web api get's error when used in a table with append other tables.

Hi,   I've got a sheet in Power BI that consists of several merged sheets. Now, I want to run a web api( the HERE geocoder api) on the final sheet but I get the error please rebuild this data com...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi,
    I've fixed the issue by using the Relative path option.
    My function now looks likes this:
    = (coding as text) =>
    let
        Bron =  Json.Document(Web.Contents("https://geocoder.api.here.com/6.2?app_id=xxxxxxxxxx&app_code=xxxxxxx", [RelativePath="geocode.json", Query=[searchtext="coding"]]))
       in
    Bron
    I hope this helps other people that run into the same problem :)

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Anonymous ,

I'm afraid that you'd better show the sample code which could reproduce your scenario so that we could help further on it.

In addition, ImkeF  and MarcelBeug  may have other ideas.

Best Regards,

Cherry

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi,
I've fixed the issue by using the Relative path option.
My function now looks likes this:
= (coding as text) =>
let
    Bron =  Json.Document(Web.Contents("https://geocoder.api.here.com/6.2?app_id=xxxxxxxxxx&app_code=xxxxxxx", [RelativePath="geocode.json", Query=[searchtext="coding"]]))
   in
Bron
I hope this helps other people that run into the same problem :)