Forum Discussion
Advocate IVIs it possible to display the latest data values?
Is it possible to display the latest data values?
For example to display values in the last 20 seconds from now, and refresh it every second or so?
Or to display the last 20 values of a specific data field, and also refresh this.
I need this in order to display real-time data properly.
5 Replies
- andre
Memorable Member
JBeyers if you have development background, you may want to check out this link:
https://msdn.microsoft.com/en-us/library/mt267603.aspx?f=255&MSPPError=-2147217396
if you don't, then you don't really have a good option for real time updates. You can either schedule your model to refresh hourly (with some limitations) or have your IT department promote your model into Analysis Services (AS) and then have AS refresh as often as necessary/possible.
- bsjut
Advocate II
What I don't get: If I'm using the REST API, how do I get PowerBI to display only the latest values on app.powerbi.com - for me it doesn't do an automated refresh?
- JBeyers
andre Sorry about didn't mentioning I'm using PowerBI at the output of an Azure Stream Analytics Job. So normally, real time updates are taken care of. It is really the displaying of the last values that concerns me. I can't manage/find an option to configure how many datavalues I can see in my graph.
So for example: I want to configure my graph that it displays 20 datavalues, and that it refreshes every 1/5/10 seconds.bsjut Do you mean the graph doesn't refresh or that PowerBI doesn't load/receive the latest datavalues? Because with the usage of an Azure Stream Analytics Job, this should work. I don't have experience with the usage of the REST API feature.
- bsjut
Yeah, I mean: when pushing REST API data, the graph doesn't update.
- JBeyers
Can you try to display the number of datavalues in a "map" chart? I'm also facing some real-time issues with the visualization in line-graphs. When using a map chart, I can see that the latest pushed values are ingested into PowerBI
