Help Required with Plotting Airport Codes

[Anonymous]

Hi there, 

I am looking plot Airport IATA Codes (e..g LHR = London Heathrow, AMS = Amsterdam etc.) on a map in Power BI but am unable to get the software to recognise where/what these are and plot these.

Does anyone know a solution to this or have access to a public airport lookup table, that I could use to get country, city etc. from please?

Any pointers in the right direction would be appreciated from me

[rachaelwalker]

You can use https://aviationstack.com/ and use a free API to get airports. Here is an example of what the API will return

Once you have an API key (free is limited to 100 calls per month), you can use the web connector in power bi and plug in

https://api.aviationstack.com/v1/airports?access_key=INSERT YOUR KEY HERE

If you want to increase the number of returned results add &limit=5000 to the end

https://api.aviationstack.com/v1/airports?access_key=1234567abcd&limit=5000

[v-yilong-msft · Accepted solution]

Hi @Anonymous ,

I’d like to acknowledge the valuable input provided by @lbendlin . His initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.  

In my investigation, I took the following steps.

You can find public airport lookup tables that provide information about airport IATA codes, including their corresponding city, country, and coordinates. I think you can use OurAirports and  SkyVector, here is the link: ourairports.com and skyvector.com.

If you’re using the OurAirports data, you might need to perform some data transformations in Power Query (Power BI’s data preparation tool). Create an index column in Power Query, select the index column, and unpivot other columns.

Then you can drag the columns to visual to get what you want.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Airport codes | ICAO, IATA international codes, location, coordinates (airportsbase.org) has lat/lon as well.  Pretty sure there are other places on the interwebs that have the same information, like GitHub - ip2location/ip2location-iata-icao: This list contains the airport codes of IATA airport cod...