Live Webservice API Consulting

[wcasasjllo]

Hi guys!

I have a lot of APIS that return information on JSON format. We need a live report that let to consume the APIS and return the information on real time.

Example: The API returns id, name, status, timestamps of a register, and in some moment the status of a specific register can change, and if the user try to search that register on the report it needs to get the recent updated data.

How we can solve this?

Thank you!

[Jayendran]

Hi @wcasasjllo ,

The direct answer is as of now PowerBI don't have a feature of Live connections to Web source/API only Import mode is supported. 

However there are some good workaround which you can use like streaming data etc, Please refer to the below link

https://community.powerbi.com/t5/Service/3rd-Party-API-with-Live-connection-refresh-on-each-request/...