web api

[emmaclarke83]

I have been given a link to a web api from one of our suppliers to access data in addition to a username and password.  Is it possible to access this web api from Power BI and model the data and output reports?  If so, can you provide some guidance?  I am not familiar with web programming. Thanks

[ZappySys]

Please look at below blog post see it helps. Using ZappySys ODBC API drivers you can import any REST API. It support HTTP Basic Auth too (User name / password )  

https://zappysys.com/blog/howto-import-json-rest-api-power-bi/

ODBC Driver - Configure API connection for JSON / XML / CSV API

ZappySys ODBC JSON Driver - Configure REST API callZappySys ODBC JSON Driver - SQL Query Preview (Read from JSON / XML / CSV File or REST API

[v-yulgu-msft · Accepted solution]

Hi @emmaclarke83,

Yes. Power BI desktop supports Web API as data source. If your API is presented as an ODATA feed, please use "OData Feed connector" (Home -> Get data -> OData Feed) to create connection to web API. If the API is a common one, please choose "Web" (Home -> Get data -> Web) connector to fetch data.

Here are some reference:

API Strategies with Power BI

Using a REST API as a data source

Best regards,
Yuliana Gu