Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
Maria_Maria
Helper II
Helper II

Bing API alternative

‎10-01-2021 08:26 AM

Hi!

I have a set of addresses and I need to populate a map in one of the dashboards I am creating with them/ 

To create longtitude and latitude I used Bing API, but it has very small requests limit. The same with Google API.

Could you please let me know what is an alternative to get longtitude and latitude for adresses?

Thank you!

 

Labels:
Message 1 of 3
527 Views
0
1 ACCEPTED SOLUTION
PhilipTreacy
Super User
Super User

‎10-01-2021 05:32 PM

Hi @Maria_Maria 

You can use the InvokeAfter() function to throttle your API calls and stay within the limits

https://blog.crossjoin.co.uk/2015/04/30/using-function-invokeafter-in-power-query/

Solved: Delay a web query before calling it - Microsoft Power BI Community

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Message 2 of 3
438 Views
2 REPLIES 2
PhilipTreacy
Super User
Super User

‎10-01-2021 05:32 PM

Hi @Maria_Maria 

You can use the InvokeAfter() function to throttle your API calls and stay within the limits

https://blog.crossjoin.co.uk/2015/04/30/using-function-invokeafter-in-power-query/

Solved: Delay a web query before calling it - Microsoft Power BI Community

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.

Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Message 2 of 3
439 Views
Maria_Maria
Helper II
Helper II
In response to PhilipTreacy

‎10-03-2021 03:16 AM

@PhilipTreacy thanks!!!

Message 3 of 3
389 Views

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All