Forum Discussion
Analyze in Excel - Date field issue
It is 2020 and still no solution for this?
A pivot-table with only string values makes the whole "analyze in excel" function pretty obsolet.
I need to be able to sort, filter and sumif sales relative to the date column and a storenumber column. As there will be up to 300.000 rows there is no other option in sight.
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.
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.
