Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
Using a REST API as a data source
Best regards,
Yuliana Gu
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/
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:
Using a REST API as a data source
Best regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |