Forum Discussion
Streaming Dataset DateTime Field Date Hierarchy Missing
dparkinson I am guessing that you're using Streaming datasets option in power bi service and building your reports and dashboards there. For date hierarchy to work, column has to be defined as of type DateTime. In power bi service currently you don't get that ability to change column data type and that is why you're not getting that hierarchy I guess. As if you would have used power bi desktop to build reports and published you would have ability to define column data type in desktop and make sure hierarchy works. In short I believe since column type isn't recognised properly of data type Date you're not getting hierarchy.
- Thanks for the response. I'm not sure that is the case though since when creating the dataset I explicitly defined the data type as DateTime. In addition the time based series for the real time tiles would indicate it is recognising it as such since it would let me use that for the axis if it was only a text field.
As dparkinson , this is NOT the case because you cannot change the datetime type in desktop, it's greyed out; but it is saying it's a datetime
See also 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
