Link/Upack WebCal Link in Queries

Howdy all, I'm a very novice user to be honest.  We am starting to build some tools and have had sucess creating a public report page showing current week events from a shared event calendar in our O365 environment.  I have that linked to a window on some digital signage in our warehouse.  The next report would come from a iCalendar link outputted by one of software platforms we use for scheduling.  When I place the data (web) in my query and double click to open, I get a single column with roughly 17,000 rows.  It is breaking out every single piece of info into a specifc row.  Each event starts with a BEGIN:VEVENT row and ends with a END:VEVENT row.  The info (that resides between those markers) that I'd like to pull out would be DESCRIPTION, DTSTART, DTEND, LOCATION, and SUMMARY.  Each of these would be a column that I could map to the fields from the cool little Calendar Visual from MAQ that I am using for the shared calendar report.  This would want to re-run a few times a day (unless is too data heavy) as schedules are constantly being updated.  Do I need to double step through Power Automate?  Thought, prayers?  Thanks in advance!