3rd Party API with Live connection refresh on each request

Hi viveknarang,

 

Generally, when we use the Web connector to retrieve data, only import mode is support. We need to set schedule refresh or manually refresh to update data. 

 

For your requirement, you can create a streaming dataset and create dashboard tiles from this dataset, see: https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming

 

To create a streaming dataset for the data source in your scenario, you can try below methods: 

 

1. You can utilize Microsoft Flow get data by calling this 3rd party REST API, then push data to Power BI as a streaming dataset, see: https://powerbi.microsoft.com/en-us/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/

 

2. You can use Power BI REST API to push the retrieved data to Power BI service. But this requires coding skills. See this example: http://community.powerbi.com/t5/Developer/Stream-Dataset-for-local-SQL-Server-Database-Query/m-p/107540/highlight/true#M3754

 

 

Best Regards,
Qiuyun Yu