3rd Party API with Live connection refresh on each request

[viveknarang]

We wanted real time data refresh for our power BI published reports Connecting throught 3rd party REST API ,Currently we can schedule refresh we wanted a live connection

Thanks 

Vivek Narang

[v-qiuyu-msft]

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

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/107...

Best Regards,
Qiuyun Yu 

[viveknarang]

Hi @v-qiuyu-msft

Thanks for your reply i did considered same approch before putting up the question .

We wanted a real time data and also person generating /desiging report should be able to change the dynamic parameters which is again disabled once we publish to power BI service  ,Can there is way we request data through api by changing parameters .

[v-qiuyu-msft]

Hi @viveknarang,

Parameters tab does work on Power BI service now. You can modify the value from 19886 to another value, then Apply button is available. 

Best Regards,
Qiuyun Yu