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...
This is not good. This has to be fixed.
When using Analyze in Excel: When I pull in a Power BI dataset via Excel, columns defined as numbers come in as text. When I drag a numerical column into Rows of a Pivot Table Field, the numbers are now seen as TEXT. The option to sort the column is A-Z or Z-A. The sort option should be Smallest to Largest or Largest to Smallest.
Is there any solution to this on-going issue?