Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |