Forum Discussion
Use google geocoding api in measure.
I have a dataset of restaurants and addresses. I want to create a dashboard where I choose the restaurant and it outputs the longitude and latitude. For that, I want to use google API. I have seen a lot of tutorials where they use this API but they simply add a new column with the coordinates. The problem is that my data frame is BIG, and also the API keys (free) uses are limited. I would just like to "run" this API in the address that was chosen by the user (a measure) at the time. Can someone help?
1 Reply
- parry2kSuper User
Anonymous maybe dynamic parameter can help, read it here Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!