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 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!
4 Replies
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?
