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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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