Apr 06 2022 03:27 AM
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 from Web" process and all, but when selecting the data to parse from, the selector wants to act like nothing is there. Can someone advise how to set this up properly? I would appreciate it!
Apr 06 2022 03:53 AM
@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!
Apr 06 2022 04:07 AM
Apr 06 2022 04:17 AM
@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?
Apr 06 2022 04:38 AM