Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
2 years ago
Solved

Pullinfg data from website to report

Hi All, I am developing a dashboard based on a public website. Here’s what I’ve done: Get Data > Click on Web > Entered URL > Load. This loaded 4 tables for me: All Main Displayed Text HTML...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  sdhn ,

     

    As far as I know, Power Query fetches data from websites that are static, and can only fetch existing data and fixed elements in the site, the content of the site is loaded asynchronously by the site scripts, and if you want to fetch dynamic data from the site, you may need to search for the relevant backend API for the source data.

     

    This is the related document, you can view this content:

    Extract data from a Web page by example - Power Query | Microsoft Learn

     

    Best Regards,

    Liu Yang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  sdhn ,

 

As far as I know, Power Query fetches data from websites that are static, and can only fetch existing data and fixed elements in the site, the content of the site is loaded asynchronously by the site scripts, and if you want to fetch dynamic data from the site, you may need to search for the relevant backend API for the source data.

 

This is the related document, you can view this content:

Extract data from a Web page by example - Power Query | Microsoft Learn

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.