Forum Discussion
real time streaming data set issue
Hi ,
I am loading the streaming data from Streaming Analytics job to power BI service and able to see the dataset created in Power BI service. I am changed the streaming dataset to Hybrid dataset by turning on the Historical data property where Power BI service will keep the data in cache and it will remove the data with FCFS method. I am using line chart for the Hybrid dataset and data is coming but the issue I am facing is on seeing the above image the inference we make is both green and red line are in the same time range window but actually they are not with slight difference in timestamp. My question is in a particular time range window either green line should come or red line should come not both. How to overcome this issue ?
5 Replies
Hi gowrishankar65,
I think this issue should more related to your data, it seems like you push multiple records at same time with both actual and alarm label. Then your chart analysis/display these history records as two lines.
Regards,
Xiaoxin Sheng
Hi Anonymous,
Thanks for your reply :) As I said earlier, the red line is showing data for different timestamp and green is showing for different timestamp. The issue I figure out is due to x-axis type as continuous. By changing the X-axis type to categorical below is the output for green and red lines.
This approach will not work since I am getting real time data for every 30 seconds. For x-axis = continous, I want to see green and red for different time range window.
Regards,
Gowrishankar
Hi gowrishankar65,
Maybe you can consider to use history data to create visual, it support more visual types than live stream tiles.
BTW, current power bi desktop support to connect power bi service datasets, you can do some custom on them and publish them to power bi service.
Regards,
Xiaoxin Sheng
