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
