Forum Discussion

Sebllo's avatar
Sebllo
Frequent Visitor
6 years ago

Hierarchy for push dataset

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 ...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
6 years ago

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-streaming-datasets

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

 

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