Forum Discussion
Need Assistance Creating Dynamic Spreadsheet Containing Flight Data
Hello: The below screenshot is what I am working with. I am trying to create a dynamic Excel sheet that updates with the flights departing at the time of refresh. It makes it through the "Get ...
Dillonm92 Googled around a bit. FlightRadar24 isn't really providing any data in a useful format, as many others. But, I stumbled on a site in the link below and that does provide data in a proper table format that you can connect to with Power Query.
https://uk.flightaware.com/live/airport/KSBD/departures
Give it a try!
- How do I connect it to power query?
Dillonm92 Sorry! When you click "Get Data", "From Web" you are in fact using Power Query. Isn't that what you were trying to do?
- When I do it that way it doesn't work. But when I open the PQE using the method you described on your first reply, it works like a charm. Thank You!
