Forum Discussion

dparkinson's avatar
dparkinson
Advocate I
9 years ago

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 str...
Need Help
dparkinson's avatar
dparkinson
Advocate I
9 years ago

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.

 

 

 

akovacs's avatar
akovacs
Frequent Visitor
9 years ago

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.