Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi everyone,
I'm new to powerbI and i'm struggling to use the Web API.
I need the data that are here
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.
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
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
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
Hi @Raphi84,
In Query Editor, you can transform this data. You can see attached pbix file.
Best Regards,
Qiuyun Yu
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 7 | |
| 6 |