Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Loading data from dynamic URLs

Good afternoon I have 5 URLs (webservices) where in the URL, ONLY the ID (1, 3, 5, 7, 10) and the year changes. The tables of the 5 URLs that contain the data are exactly the same, only the id and t...
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi  Syndicate_Admin ,

 

You can use PowerBI Desktop to batch collect data from multiple web pages from the following blog.

Note: If the list of original column names contains names that do not exist in the table, an error will be reported.

https://community.powerbi.com/t5/Community-Blog/Batch-crawling-web-page-data/ba-p/1715990

 

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.