214
When connecting to Power BI datasets using Analyze in Excel, all date fields from models show up in pivot tables as text, which disables filtering or grouping for date groups.

It is possible to fix this or give us a workaround to set columns as date?

Thanks!
STATUS DETAILS
Planned
2022 Release Wave 2

This is an Excel feature that is being actively worked on by the Excel team. Updates to follow.

Comments

P

This is really really bad..

P

I totally agree to most of the comments. This problem should be solved. Thank you for your attention. I’m looking forward to a reply.

P

Peopel are complaining about this issue since 2017. Realy? Within 4 years you can't make your one of the most importat applications talking together in same Date Format? Saying that this is ridiculous is like saying nothing.

P

I just wasted 8h to end up here. My rage cannot be put into words. How can this issue exist for at least a year and it is still not fixed. Like literally everyone stated the "analyze in excel" is completely useless without this fix.

P

The work around I found was to create a Measure in PowerBI.

When this is connected to via the OLAP cube it comes in as a date value



m_Scheduled Month = SUM('Scheduled Revenue'[ScheduledMonth])

P

This will be good. Thanks again Andrew

P

This is incredible! I can´t believe it
How much do we have to wait?

P

Getting a bit ridiculous having to wait this long. I agree makes analyzing in excel obsolete.

P

Why is this even a voting issue??? I mean, I can deal with the fact I have to use measures for values. But it's a Microsoft to Microsoft product, why isn't the date passed.

At least if I could connect to the source in the power query section of excel I could reformat.

P

There are a few other requests for the same thing.
This issue makes the analyze in excel rather difficult to use