Connect to API

Hey,

as your question is quite generic, I just can provide a quite generic answer. This answer is simply this: Yes!

But each project that is tasked with fetching data from a web-based API has its intricacies. This is due to the implementation of the API and also how the connection to web based data sources is implemented in Power Query, especially the automatic refresh if the report is finally published to the Power BI service.

This article will provide a good start: https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-importing-and-analyzing-data-from-a-web-page

Hopefully this provides what you are looking for.

Regards,

Tom

Hi antu3 ,

What authentication does the API support? There is a blog about how to connect to API in Power BI Desktop for your reference:
https://chris.koester.io/index.php/2015/07/16/get-data-from-twitter-api-with-power-query/

If your are connecting to a REST API, you can refer to the similar post: https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400

Best regards,

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