Forum Discussion
Google Maps Distance Function Help
Hi TGoodheart,
From your description, it seems that you want to pass dynamic destinations to in URL to generate data. Please try to use the Web data source to call Google Maps API firstly follow this to see if the distance can return. Then follow those articles to create custom function and invoke it.
Using The Invoke Custom Function Button In Power BI
Custom Functions Made Easy in Power BI Desktop
Besides, there are errors with three queries when you apply changes, I would suggest all those three queries one by one. By the way, please try to run the latest desktop version.
Best Regards,
Qiuyun Yu
Community SupportHi TGoodheart,
From your description, it seems that you want to pass dynamic destinations to in URL to generate data. Please try to use the Web data source to call Google Maps API firstly follow this to see if the distance can return. Then follow those articles to create custom function and invoke it.
Using The Invoke Custom Function Button In Power BI
Custom Functions Made Easy in Power BI Desktop
Besides, there are errors with three queries when you apply changes, I would suggest all those three queries one by one. By the way, please try to run the latest desktop version.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft,
Thank you for responding. I found out that I was running up against the API call daily limit, I kept the first 2.5k rows and the queries worked.
Thank you for the help!
TG
