Extract table from webpage

[AlexisPREVOT]

Hi,

I want to extract all the data table from this web page : https://public.opendatasoft.com/explore/embed/dataset/economicref-france-sirene-v3/table/?disjunctiv...

But it seems not to be able to recover the data.

I use the web source and enter the web adress as it explains in the Microsoft documentation.

I get this in the table display:

And this in the web display :

when I validate the operation I just get:

So I just get the column names but not the data in the columns.
I tried to create the table with examples with no more success ...
Can you please help me?

Thank you by advance,

Alexis

[selimovd · Accepted solution]

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 regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[AlexisPREVOT]

Thank 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.