Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
Solved! Go to 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
Proud to be a Super User!
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
Proud to be a Super User!
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.
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.
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.
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 .
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
111 | |
95 | |
92 | |
86 | |
69 |
User | Count |
---|---|
162 | |
129 | |
125 | |
104 | |
98 |