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...
Agree! Analyze-in-Excel is an important part of the whole Fabric platform. Numeric values seen as text is a very odd issue to miss when sourcing a Power BI dataset from the service into Excel. I am thinking it is by design but cannot think of a valid reason why it would be. If there is no valid reason, then why has it not been fixed? This has been a long standing issue.
What I mean is, if you as an organization intend to support A-in-E you need to design for it. It's a transitional capability that introduces complications in managing the capacity, I wouldn't expect them to put many resources into fixing it.