cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
viveknarang Frequent Visitor
Frequent Visitor

3rd Party API with Live connection refresh on each request

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 Narangpower bi.png

 

3 REPLIES 3
Moderator v-qiuyu-msft
Moderator

Re: 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-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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
viveknarang Frequent Visitor
Frequent Visitor

Re: 3rd Party API with Live connection refresh on each request

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 .power bi.png

 

Moderator v-qiuyu-msft
Moderator

Re: 3rd Party API with Live connection refresh on each request

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 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.