Dynamic API calls

[Krcmajster]

Hope this is not a stupid question.

In Alteryx I was able to create nice visual (in ppt or pdf) with goolgle APIs. I used them to geocode (not necessery here) and find nearby places. 
Basically when a location was entered a person would get nearby places (Download, JSON parse). 

My question is, can something like this be achieved in Power BI just for it to be dynamic?

What I would like is for a person to select a location, enter radious (parameters) and then get the places in the given radious (download the long and lat). This can be achieved with Web connection but the issue is that it's static and since I have a lot of location it might overload the power BI. 

[Anonymous · Accepted solution]

HI @Krcmajster ,

>>This can be achieved with Web connection but the issue is that it's static and since I have a lot of location it might overload the power BI. 

You can create a table with each user location and package call web api steps with web connector as a custom function.  Then you can add a custom column to the above table to loop each row records and invoke the custom function.

Power Query: Creating a parameterized function in M

Regards,

Xiaoxin Sheng

[Krcmajster]

@Anonymous brilliant, thanks