Date hierarchy using SSAS Live Connection

[Delion]

Hi how to use Date hierarchy in power BI with SSAS Live Connection ?

[amitchandak]

@Syndicate_Admin , I think this limitation with live connection ,

refer https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about#limited-data-transf...

Check if you can create custom Hierarchy

create a new hierarchy
https://www.tutorialgateway.org/create-hierarchy-in-power-bi/
https://www.youtube.com/watch?v=x6vXVJZ_eTY

[sayaliredij · Accepted solution]

No built-in date hierarchy is not available in Direct Query as well as Live connection mode. It will be beneficial if the SSAS model itself has a date hierarchy implemented there. 

Refer below article for more details

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

Regards,

Sayali