Forum Discussion
Help Required with Plotting Airport Codes
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
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.
3 Replies
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 code and ICAO airport code together with country code and region name supported in IP2Location geolocation database.
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.
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
