cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

How to import data from ajax web page?

Hi experts,

 

I tried import some weather data on a web page. For static data, Power Query can import them with no problem. However for data tables that uses ajax, they are not found in the preview mode of Power Query. I can copy them manually and paste them into Excel with no formatting problem but I would prefer it to be automated. Is there any work around on that? Thank you for your help.

1 ACCEPTED SOLUTION

@keajht31,

As my previous reply, you can use Get Data from Web by example feature  to extract data from the web page to Power BI. See more details in attached PBIX file.
1.PNG2.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Microsoft
Microsoft

@keajht31,

Which web page do you refer to? Please check if you can get data from the web page using Get Data from Web by example feature in Power BI Desktop.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thank you for your reply. This is the website I am refering to: https://www.hko.gov.hk/cis/dailyExtract_e.htm?y=2018&m=08

When using the "Import from web" function, the table is not found in the preview mode. I checked the website code and found that the datatable is dynamically filled. In contrast, this function works in the following website: https://www.hko.gov.hk/cgi-bin/hko/warndb_e1.pl?opt=5&start_ym=201208&end_ym=201808&submit=Submit+Qu...

 

 

@keajht31,

As my previous reply, you can use Get Data from Web by example feature  to extract data from the web page to Power BI. See more details in attached PBIX file.
1.PNG2.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Hello,

 

I'm just beginning to use Power BI. I understand Power BI can scrap ajax web page data, but I can't scrap this one:

https://www.construplaza.com/Materiales/Aceros/Tuber%C3%ADa

 

Can you help me with this please?

 

Thanks for the help. 

Thank you so much for your help. 

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors