Forum Discussion

dparkinson's avatar
dparkinson
Advocate I
9 years ago

Streaming Dataset DateTime Field Date Hierarchy Missing

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 hie...
Need Help
ankitpatira's avatar
ankitpatira
Community Champion
9 years ago

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.