topic Re: Running a Power Query - getting no data in Power Query

Running a Power Query - getting no data

gobluemba — Fri, 13 Dec 2024 17:30:55 GMT

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.

Re: Running a Power Query - getting no data

lbendlin — Fri, 13 Dec 2024 20:06:30 GMT

Maybe your data source uses dynamic HTML? What kind of source is it?

Re: Running a Power Query - getting no data

gobluemba — Fri, 13 Dec 2024 21:23:12 GMT

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!!!

Re: Running a Power Query - getting no data

lbendlin — Fri, 13 Dec 2024 22:10:31 GMT

Yeah, dynamic HTML. Forget about it. Find an API instead.

Re: Running a Power Query - getting no data

gobluemba — Fri, 13 Dec 2024 22:19:14 GMT

Thank you for checking it out.