All records from a table in a website not displaying

[Saman5]

There is no page no in the URL.

Only arrows are displaying for each table.

Please tell me how to scrap all the data from the website in the powerBi.

[PhilipTreacy · Accepted solution]

HI @Saman5 

That website is using JavaScript to display the information and you won't be able to use PBI/PQ to get the data.

You could use VBA or Python to interact with the site and get what you want, but even then you may be limited in what you can get. It depends on exactly how the site is programmed.

Further reading

https://www.myonlinetraininghub.com/web-scraping-with-vba

https://www.myonlinetraininghub.com/web-scraping-filling-forms 

regards

Phil

[v-robertq-msft]

Hi, @Saman5 

According to your description, you want to get information from the web through Power BI, I suggest you to connect to the web using web connector in Power BI Desktop, like this:

Then you can select the data you want to import to Power BI to make some transform or create visuals, like this:

And you can get what you want.

More info about connecting to a web page in Power BI

Best Regards,

Community Support Team _Robert Qin

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

[Saman5]

I had tried this but all the data from the tables is not extracting.

And the URL does not contain any page number .

Like the attached picture showing only 10 records but table contain total 116 records .so the powerBi is showing only 10 records.

 

[v-robertq-msft]

Hi, @Saman5 

According to your picture, I guess that it is not a report created by Power BI, so what’s your true meaning? What’s more, if you want to scrap all the data from the Power BI report, you can upgrade your dataset(like download the report as pbix in Service then edit the dataset in Power BI desktop) or just delete your dataset in the Power BI service.

If you still can’t solve your problem, you can share some sample pictures or pbix file so that we can help you in advance.

Thanks very much!

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[Saman5]

Hi,

This screenshot is from website https://contracts.disclosurelo.gs/displaySON.php?SONID=SON3520191&year=2019.

I want to scrap data from this website through powerBi .