Forum Discussion
Running a Power Query - getting no data
- 1 year ago
Yeah, dynamic HTML. Forget about it. Find an API instead.
Thank you for the follow-up, lbendlin
I provided some screenshots for context.
SCREENSHOT 1: I copied the URL on the page where I want to start extracting data and put it into Power Query. There is a list of individuals with records on screenshot 1 from which I want to get information.
SCREENSHOT 2: If you click on one of the records, this screen pops up. The arrows represent data I would like to populate into Power Query. However, the URL remains the same. The window doesn’t open in a new window but instead has a pop-out window.
SCREENSHOT 3: There is a tab I want to click on to get more information and responses to some questions. Once again, the URL remains the same, but the information is different in the pop-out, depending on the tab you click.
You can see the pop-out better in SCREENSHOT4.
However, and this is where my lack of technology comes in, the URL remains the same when you click through the record – so how do you navigate this and extract the data in the pop outs?
Thanks in advance!!!
Screenshot1Screenshot2SCreenshot3SCreenshot4