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...
Same issue here. I would like to use a Date field with Excel's Pivot Table Timeline feature, but when I attempt to create a Timeline, the following message appears: "We can't create a Timeline for this report because it doesn't have a field formatted as Date."
The field is formatted as a Date in Power BI, but using the Analyze in Excel feature disregards this formatting.
Facing the same issue. Is there a fix or workaround for this?