topic Connect to REST API via PowerBI in Developer

Connect to REST API via PowerBI

sniffer — Mon, 01 Feb 2021 01:42:39 GMT

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!

Re: Connect to REST API via PowerBI

lbendlin — Mon, 01 Feb 2021 03:14:39 GMT

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

Re: Connect to REST API via PowerBI

wetscott — Thu, 16 Sep 2021 04:50:11 GMT

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.