Enable SSAS and Date Hierarchy
The new auto Date Hierarchy which came out in the November update is excellent, but does not seem to be available when connecting to a SSAS Tabular Model. Desktop appears to recognise a Date field, but will now activate the hierarchy action.
Brent Leslie commented
Pretty poor that the same data type delivered in 2 different ways is treated differently by PowerBI. Will result in people not using SSAS tabular cubes
Leslie Ditsa commented
Really need this after connecting through SSAS on-prem
Melina de Montbrun commented
This is a big one for our public organization. The ability to see/drill through data in trends over time seems like a no brainer to our executive team, and without functionality like this we have to fake it, use numbers to represent months, and it just doesn't look good.
Would be awesome if this could be fixed and would impact our organization's uptake of the tool.
Very important. This renders trend lines on line charts completely unusable as they have to be in a date format. Ultra granular data daily is sometimes worthless as a visual.
The behavior needs to be the same as deployed models.
It is interesting that the Multi-Dimensional models have their complex ragged hierarchies supported in Power BI, but NOT the basic SSAS Tabular Model via on-premise live connections. It would seem to be simpler to support the SSAS Tabular Model fixed hierarchies.