Forum Discussion
Resolver IExtract table from webpage
Hey AlexisPREVOT ,
sadly you can't load the data like this from opendatasoft.
But they have an API, why don't you load it from the API as JSON. This is fully supported from Power BI.
In Opendatasoft you can usually just copy the link of the API in the "API" section:
Also the documentation of the API might help you:
https://data.opendatasoft.com/api/v2/console
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
Most Valuable ProfessionalHey AlexisPREVOT ,
sadly you can't load the data like this from opendatasoft.
But they have an API, why don't you load it from the API as JSON. This is fully supported from Power BI.
In Opendatasoft you can usually just copy the link of the API in the "API" section:
Also the documentation of the API might help you:
https://data.opendatasoft.com/api/v2/console
AlexisPREVOTThank you for your reply.
The concern I have using the API is the limitation on the number of rows I can import into PowerBi (10,000 from memory) and I don't know how to increment in steps of 10,000 in the API to get l all the information I need.