cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sniffer
Regular Visitor

Connect to REST API via PowerBI

Admittedly, I am new at this and humbly posting this online for assistance.  Thanks in advance for any help you can provide.

 

I've searched this site and have found many similar posts, but have not been able to successfully connect to a source using REST API.  My specific request pertains to the details posted on this page:  https://app.airdata.com/docs/api/

 

I'm using PowerBI desktop and am trying to connect to this data.  I have an API key using the PowerBI connect to web interface.  The first thing I did was access the base URL (https://api.airdata.com) from PowerBI.  I received a pop-up window stating that the site only accepts anonymous access.  In posts I've read here online, others have a pop-up that asks how to connect to the site with anonymously as an option.  I was not given that option.  How do I access this anonymously?

 

Secondly, since I have an API key, what is the best way to access the data?  Can I access it via the "From Web" method?  If yes,  what URL and authentication string do I need for the URL to access successfully? Or, do I need to access via code from the power query and how would I do that?

 

Much thanks!

 

 

 

2 REPLIES 2
wetscott
Helper I
Helper I

Hi there.

I'm just now trying to connect to the AirData API as well. Having a little trouble trying to follow the above links. Just can't seem to wrap my head around while refering to the AirDate API docs.

 

Did you have any luck?

 

I'm basically trying to export a list of all flights. Virtually all fields available.

 

Any guidance would be much appreaciated.

lbendlin
Super User
Super User

Read up on the optional parameters of the Web.Contents() call in Power Query.  There you can specify header, authentication, and data payload options (the latter for switching from GET to POST)

 

The hidden gems of the function Web.Contents() - Kohera

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors