Forum Discussion
Connect to API
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,
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.
3 Replies
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.Excellent article !!!!
Thank you very much for your reply.
