Automatic date hierarchy for direct query data
Automatic creation of a date hierarchy for date fields only seems to work for imported data. Please enable the same feature for direct query data!
Any news on whether this limitation has been addressed?
Agree this is a big limitation. I use power embedded and have a lot of graphs in the dashboard whit the months of the year on the x-axis. If I want use date hierachy in my graphs I have to switch to import and use the API to upload the reports manually.
Nagaraja Char commented
This needs to be fixed, as we are using date hierarchy in most of my dashboards
Brian Johnson commented
Agree with the other comments that this is a severe limitation
Renee Hughes commented
This is a severe limitation with using PowerBI because I would like to use this functionality in a dashboard that always has current data, so Direct Query is a must.
Importing is a quick fix for single uses, but not at all practical for
The DirectQuery limitations of PowerBI are pretty appalling.
Direct Query is really required for handling big size of data in perspective of data handling performance and visualization speed. Also the date hierarchy is the far base of all the Power BI works. Therefore, if Power BI want to have its motto as "Easy Big Data" it should have automatic Data Hierarchy process function for Direct Query.