Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Authentication Error

Hello there,

 

I am working at converting address information to latitude and longitude, using Bing Api trying to extract latitude and longitude information on Power Query. While I can extract information, I am facing authentication error connecting to the Api. 

Method:

  1. I created a key on Bing Dev Api Center.
  2. Used the key to parse a sample location to give latitude and longitude.
  3. Further, created a custom function with the same.
  4. Invoked the Custom Function on Location field to get lat and long.

I have tried connecting using basic, windows, anonymous authentications, but none of them are working. Can you please help ?

ogbadebo_0-1662276451109.png

 

1 REPLY 1
Greg_Deckler
Super User
Super User

@Anonymous I would think you would need to use Web API. Maybe this helps: Geocoding with Bing Map API - Microsoft Power BI Community


Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.