Analyze in Excel Using Incorrect formatting as TEXT

[CatPhish]

Using "Analyze in Excel," I find that when I open the dataset in Excel columns (as opposed to measures) that are dates are formatted as text, not dates.  There is no way to change the formatting.

I should also add that the pivot table recognizes the field as a date as I'm able to group by month/week.

THis is having a big impact on my users ability to sort our data.

Is anyone else experiencing this?  Am I doing something incorrectly when setting up my data model?

[v-yuezhe-msft]

@CatPhish ,

The issue is caused by that Power Pivot treats Date columns as text. I find several threads stating the same issue, I would recommend you report this issue in PowerPivot forum.

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c0253620-6ae0-46ea-8b6e-124e6c950239/powerp...
https://stackoverflow.com/questions/27913051/powerpivot-incorrectly-convert-date-value-to-text-in-pi...

Regards,
Lydia

[Anonymous]

I have created a idea for this. Vote!

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/40346272-analyze-in-excel-date-co...