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...
As of December 2022, this issue still exists!
What's the actual use of the Analyse in Excel/ Power BI connection if you can't:
- Create measures
- Or at least retain field numerical formatting given you can't create measures.
Essentially, if there's any new analysis that someone wants to do Excel side - it would have to be done from Power BI which is very reduntant, and gives the Excel user vertually no extra independence.
I have this issue too, it's very annoying.
While searching on Google, I found a possible workaround for this issue https://medium.com/@curtisrstallings/date-hierarchies-power-bi-analyze-in-excel-96431f735678
I didn't tested it yet but it seems a good alternative
