Forum Discussion

AlexisPREVOT's avatar
AlexisPREVOT
Resolver I
5 years ago
Solved

Extract table from webpage

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/?disjunctive.libellecommuneetablissement&disjunctive.etatadministratifetablissement&disjunctive.naturejuridiqueunitelegale3

 

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

Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    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
     

     

2 Replies

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    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
     

     

    • AlexisPREVOT's avatar
      AlexisPREVOT
      Resolver I
      5 years ago

      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.