Forum Discussion
Streaming Dataset DateTime Field Date Hierarchy Missing
I've previously asked this in the developer forum, but it's a little quiet over there, so I thought I'd try here too -- hope that's ok...
I have a streaming dataset with a DateTime field. The streaming dataset is keeping historical data. When I create a report to put on a dashboard using the DateTime field, I do not have any date hierarchy capabilities. I am therefore not able to see my data by day/month, only by time.
Whilst it's great to see the data realtime, some departments only want to see that data summarised over day/week/month not by minute. I'm truly hoping that I'm doing something wrong rather than a fundamental piece of functionality being missing.
Any thoughts greatly received.
Many thanks,
D.
9 Replies
I am having the same issue. PBI Desktop doesn't seem to support the data heirarchy feature on live streaming data. Some of the visualizations don't have the data heirarchy feature at all, even with the data type set to DateTime.
I don't have a streaming data set but maybe this will be the same: in Dataset - starting with a blank canvas, select your date field from the right Fields pane so it shows up in the canvas
then in the Visualization pane, look at it's drop down and see if Date Hierarchy is checked.......
Hi, thanks for the response. Yes, that's the point, that option is missing...
any chance the field is coming is a text field? any strange alpha mingled in to make PBI think it is text?
Hi, I am facing sort of same issue.
When "Historic Data Analysis" tab is checked, it does not take timestamp as Datetime, rather accepts it if i change it to Text.
But unfortunately I am unable to use the date hierarchy while creating reports from the same since it recognizes it as just a string.
I'm guessing this is a missing feature for streaming datasets. I've tried to accomplish your exact solution for the same reasons but failed to create the hierarchies. Adding new measures for dateparts and using those as drill down layers might work for some visuals, but to be honest I'm not about to spend that time.
The main reason behind this issue might be that creating detailed aggregated reports may not be what PBI team is aiming with streaming datasets. Let's agree on the best way they work is when you need to monitor frequent data, like sensor streams. I'm leaning towards seperating the datasets for respective purposes: real-time and warm data.
dparkinson have you found any workaround to this?
I think my issue https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Simple-cumulative-sum-issue-with-live-data/m-p/3417945/thread-id/129352 is probably the same as this one. Not only is the date hierarchy missing, but cumulative measures built off the datetime field don't work. I think this is a reasonable use-case for live stream data though - we're maybe showing live, "last hour" and "cumulative today" data so this is quite a limitation for live streams IMHO.
