Forum Discussion
Analyze in Excel Using Incorrect formatting as TEXT
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. ...
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/powerpivot-dates-turn-to-text-in-excel?forum=sqlkjpowerpivotforexcel
https://stackoverflow.com/questions/27913051/powerpivot-incorrectly-convert-date-value-to-text-in-pivot-table
Regards,
Lydia
I have created a idea for this. Vote!