Hierarchy for push dataset

[Sebllo]

Hello, 

I just noticed that it seems that hierarchies of fields are not possible with push datasets ...

Is this the case?

Do you have a workaround that could save my life ? and especially a lot of working hours, having carried out all my tests with an Excel source, before doing my final integration with a push dataset ...

Thank you again for your help.

Cheers. 

[v-lili6-msft]

hi @Sebllo 

The Hierarchy is not available in push dataset for now.

Here are the ideas, you could vote for them:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/33175456-date-hierarchy-for-strea...

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/34420282-hierarchy-s-in-push-api-...

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.

Regards,

Lin