API web data source : what is the best way ?

[florentbignier]

Hello,

I have a list of interventions in a table. Each intervention concerns a school. The list of schools is available in web API.

In my reporting, I need to extract some informations from this list (the city, for example). I thought of 2 solutions to do that with Power BI Desktop :

- Import all the list (there are more than 65000 lines) in a table (but I do not know how to import such a quantity of data)

- Access live (but I do not know how to request the API for each school)

Thank you in advance for your advice and tips !

Florent

PS : API URL : https://data.education.gouv.fr/api/records/1.0/search/?dataset=fr-en-adresse-et-geolocalisation-etab...

[v-juanli-msft · Accepted solution]

Hi @florentbignier

Please check these reference

Tutorial: Importing and analyzing data from a Web Page using Power BI Desktop

API Strategies with Power BI

how to connect my web api wtih Power BI Reports?

Best Regards

Maggie