Connect to API

[antu3]

Hello,
From the Power BI I would like to access an online API. If I can access the API through a web browser and I can download data in JSON format. But I would like to access directly from the Power BI and update it.
It's possible?
Regards,

[TomMartens · Accepted solution]

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-p...

Hopefully this provides what you are looking for.

Regards,

Tom

[v-lid-msft · Accepted solution]

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.

[antu3]

Excellent article !!!!
Thank you very much for your reply.

[TomMartens · Accepted solution]

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-p...

Hopefully this provides what you are looking for.

Regards,

Tom