Power BI Get Data Website Javascript Multipable Page

[resatayvaci]

Hello, I used Excel to get data from websites in the past, but I realized that Power BI is better at analysing the table on the website. In summary, I am new to Power BI. I want to share my concern. If you could help me, that would be wonderful for me. Thanks in advance.

There is a website where I want to extract data. The website is "https://catalogue.ite-expo.ru/en-GB/exhibitorlist.aspx?project_id=505". This is the list of exhibitors for the fair. The page is limited to 25 displays and there are 32 pages more. I can only get the first page using get data. There is no way to display them on one page on website. Also, the other page links go through JavaScript code. Please see the link for the second page of the website. "javascript:__doPostBack('p$lt$zoneContainer$pageplaceholder$p$lt$zoneForm$UniPager$pagerElem','2')" Can you please tell me how I can get other pages too?

[Anonymous]

Hi, @resatayvaci

Based on your question, I also connected to the Web and extracted the data.

I think you can use Custom Column to modify the number of pages you need , so that you can repeat the above steps to get the final data you need. You can also read the following documentation for more information: Scrape Data from Multiple Web Pages with Power Query • My Online Training Hub

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Yilong Zhou

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

[resatayvaci]

The article you have shared is for URL-paginated websites. This website displays other pages with Java functions. I do not know how to call and display the next function on the Power BI. Could you please share a similar example so that I can understand it?