Forum Discussion
Analyze in Excel - Date field issue
When using 'Analyze in Excel' Date fields from my model show up in excel as text which really limits the usage of the Analyze in Excel functionality. Has anyone else encountered this and come up with...
I'm facing the same issue. I'm looking into PowerBI for the company I work for, largely because of the "Analyze in Excel" feature. I agree that not having dates working properly severely limits this feature's usefulness.
The obvious workaround is to create separate day/month/year fields in the dataset, but this is not ideal as it leads to confusion for end-users and broken reports down the road once they fix this issue (and remove said fields), etc.