Forum Discussion
Running a Power Query - getting no data
Hello,
I am trying to use Power Query in BI. When I insert the link, I get no data. Is this a configuration issue? I am not a techie, so it might be something simple - just unsure. Thanks in advance! I also try to do web view, and it doesn't show a web page.
Yeah, dynamic HTML. Forget about it. Find an API instead.
4 Replies
- lbendlinSuper User
Maybe your data source uses dynamic HTML? What kind of source is it?
- gobluembaHelper I
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
- lbendlinSuper User
Yeah, dynamic HTML. Forget about it. Find an API instead.