Forum Discussion

erhodes's avatar
erhodes
Advocate II
9 years ago

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...
General Comment
j_ocean's avatar
j_ocean
Helper V
2 years ago

The other option would be using PBI service...

 

If analyze-in-excel is part of the planned enterprise PBI architecture, data models need to be built for it e.g. creating a measure summing your dollar values and having dates broken out to their higher aggregations. Then it should work.

roncruiser's avatar
roncruiser
Post Patron
2 years ago

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.

  • j_ocean's avatar
    j_ocean
    Helper V
    2 years ago

    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.