Forum Discussion

gobluemba's avatar
gobluemba
Helper I
1 year ago
Solved

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. 

 

 

  • lbendlin's avatar
    lbendlin
    1 year ago

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

4 Replies

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

    • gobluemba's avatar
      gobluemba
      Helper 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

      • lbendlin's avatar
        lbendlin
        Super User

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