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
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!
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.
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)
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |