cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
emmaclarke83
Helper I
Helper I

web api

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

1 ACCEPTED SOLUTION
v-yulgu-msft
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
ZappySys
Helper I
Helper I

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 APIODBC Driver - Configure API connection for JSON / XML / CSV API

 

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

 

 

v-yulgu-msft
Microsoft
Microsoft

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!