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...
Hello everyone.
I'm coming from https://community.powerbi.com/t5/Service/Analyse-in-Excel-and-Date-Format/m-p/1061012#M94618
Is there any way to force columns to date format ?
I have many dates formatted as date in powerbi that powerpivot with analyse in excel reads as text and I want to filter them using power pivot date filters.
One workaround could we to load the data to power query instead of connection to the pbiazure and changing to date there. But I don't think this is possible, right?
I have created a idea for this. Vote!
How does this only have 5 votes? C'mon people, you know what to do!
