The date hierarchy feature with PowerBI imports is very user friendly, especially for role-playing dimensions.
If you have an OrderDate and ShipmentDate both can be located on the same table in the fields explorer, and hierachies show up when selected. Also, both of these role-playing dates works as active relationsships at the same time.
However, I find it hard to achive a similar user friendlines with Live connection to SSAS Tabular.
What are your recommendations to get closest to that functionality???
The docs say: Using DirectQuery in Power BI:
No Built in-date hierarchy: When importing data, then by default every date/datetime column will also have a built-in date hierarchy available by default. For example, if importing a table of sales orders including a column OrderDate, then upon using OrderDate in a visual, it will be possible to choose the appropriate level (Year, Month, Day) to use. This built-in date hierarchy is not available when using DirectQuery mode. Note however that if there is Date table available in the underlying source (as is common in many data warehouses) then the DAX Time Intelligence functions can be used as normal.
The closest I get, is creating a SSAS date table and creating calculated tables from this, in order to allow multiple date-relationships to be active at the same time. However
1) only one table can be marked as date table
2) the fields menu gets extremely cluttered with date tables separated from their facts.
