Forum Discussion
Streaming Dataset DateTime Field Date Hierarchy Missing
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?
So, to be clear, this is a streaming dataset with the field set as a DateTime field. When shown on a live tile, it shows the data updating every 30 seconds (as that is how often I'm updating the data), so the field is recognised ok as a date time field. It's just that when I put the field onto a normal report (rather than realtime), date hierarchy is not an option so that I can view average stats over a day/week/month/year etc.
I hope that's clearer.
Hi,
I'm facing the same issue. I can only use date hierarchy when I use a normal (not streaming) data source.
As a workaround, I pushed the same JSON data to Azure Event Hub, then with a Stream Analytics job copied it into a DocumentDB database.
The DocumentDB database can be used as source with Power BI Desktop. If you publish the report to Power BI online service, data can be refreshed with a schedule (pro feature) automatically from Azure DocumentDB. Since the source is not a stream anymore, it is not useful to show real time data on a dashboard, but you can build better reports.
However, if you keep pushing the same data (same JSON string) straight to Power BI too, you can display that data on a dashboard in a real-time way.
