Forum Discussion
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 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.
1 Reply
v-lili6-msftCommunity Support
hi Sebllo
The Hierarchy is not available in push dataset for now.
Here are the ideas, you could vote for them:
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