Analyse in Excel and Date Hierarchies

[AndrewSinha]

Hi

First time poster and really quite new to PBI. 

I have craeted a model in the desktop. The model has the auto date hierachies which is good for me as it's not financial information and as long as I can sort group on months etc that all is good.  It works in the PBI desktop.  I've published it to the service, into a workspace that I share with a collegue. 

My question

When I "Analyse in Excel" the resultant report opens in a pivot table but the date is not formated as a date and there is no date hierarichy. What do I do now?  Do I create a date table in my PBI desktop and add the relationships or is ther someting I can do in excel?

Thanks 

Andrew

Hopefully this is clear

[AndrewSinha]

Thank you very much.

[Shahfaisal · Accepted solution]

I think this is a limitation that is being addressed. Can you please go ahead and vote on the below idea and add a comment?

https://ideas.powerbi.com/ideas/idea/?ideaid=e9b77e43-84bc-4440-9e3f-0725dcf60cd3