Get data from API WEB - Open Data soft website

[Raphi84]

Hi everyone,

I'm new to powerbI and i'm struggling to use the Web API.

I need the data that are here

https://www.data.gouv.fr/fr/datasets/base-sirene-des-entreprises-et-de-leurs-etablissements-siren-si...

It's quite à big file (8GO)

Lucky for me, i found a link in opendatasoft where the data are upload and i can filter and go down to 200Mo.

https://public.opendatasoft.com/explore/dataset/sirene/export/?refine.libapen=Coiffure&dataChart=eyJ...

Still, i managed to export a csv files. Good for me, but i couldn't link directly the data by the API.

I only have the number of lines of my export.

I'm close... but what i am doing wrong?

Thank you.

Bye

[v-qiuyu-msft]

Hi @Raphi84,

As you can see from here, this dataset can be consumed via an API, you can enter values for various criteria exposed in the console below, then copy the generated URL below the console, use Web data source in Power BI desktop and use this URL to get data. You might need to go to Query Editor to resolve record or list data. 

Best Regards,
Qiuyun Yu 

[Raphi84]

Hi @v-qiuyu-msft,

Thank you for answering me.

I've seen the link before, but when i try the wep api, the integration give this:

Seems to be a sumup of the data not the data itself...

Thank you again for your time.

Regards.

Raphaëlle Rougeau

[v-qiuyu-msft]

Hi @Raphi84,

In Query Editor, you can transform this data. You can see attached pbix file. 

Best Regards,
Qiuyun Yu