How to get external data which is in website to Power BI Desktop

[naveen_85]

Hi,

i am trying to pull the report from external web page to Power Bi desktop but i observed that in that web page it has more rows alomost 292,720,924 , my question is  there is any way to extract the huge data from web page to power bi desktop?

please guide me if you have any alternative solution, since i am new to PBI.

Thanks in advance,

[v-angzheng-msft · Accepted solution]

Hi, @naveen_85 

Scraping data from multiple web pages, we can use PowerBI to achieve it. Here is a feature "Add Tables Using Examples" can help us. We can use this feature to scrape the information  we need on the web page.

Then we can create a scrape data function through PowerQuery and keep calling the function to get data from multiple pages.
For simple Scraping data work you can use PowerBI to do this, but for professional works you may need to learn more about professional computer knowledge to help you, which cannot be discussed here.

Please refer to the video tutorial below for a detailed process of Scrape Data from Multiple Web Pages.

https://www.youtube.com/watch?v=VkDpwSGWPmk

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[naveen_85]

Thank you team for your prompt response.... Much appreciated.. 

[naveen_85]

Hello Amit,

thanks for your input, but i need to take the data from the external web page from that how to do pagination?

since it is showing many suppliers ( below screen for reference ).

[amitchandak]

@naveen_85 , can pagination help here ?

example https://medium.com/@marktiedemann/how-to-do-pagination-in-power-query-430460c17c78