Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 a solution.
Facing the same issue. Is there a fix or workaround for this?
Has this issue ever been resolved? I am connecting to the PowerBi service (OLAP) and I am having the same issue with dates showing up as text in pivot tables.
I'm facing the same issue. I'm looking into PowerBI for the company I work for, largely because of the "Analyze in Excel" feature. I agree that not having dates working properly severely limits this feature's usefulness.
The obvious workaround is to create separate day/month/year fields in the dataset, but this is not ideal as it leads to confusion for end-users and broken reports down the road once they fix this issue (and remove said fields), etc.
Hi @erhodes,
Based on my test, PowerPivot changes the format of date columns to General when I use “Analyze in Excel” feature. From my point of view, the issue is related to PowerPivot, I find a connect item and several threads stating the issue that PowerPivot treats date columns as text, I would recommend you post the question in the Power Pivot forum to get dedicated support.
And you can also check the following similar threads.
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/c0253620-6ae0-46ea-8b6e-124e6c950239/powerp...
http://stackoverflow.com/questions/27913051/powerpivot-incorrectly-convert-date-value-to-text-in-piv...
Thanks,
Lydia Zhang
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.