It is possible to fix this or give us a workaround to set columns as date?
Thanks!
Comments
This is really really bad..
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.
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.
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.
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])
This will be good. Thanks again Andrew
This is incredible! I can´t believe it
How much do we have to wait?
Getting a bit ridiculous having to wait this long. I agree makes analyzing in excel obsolete.
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.
There are a few other requests for the same thing.
This issue makes the analyze in excel rather difficult to use
Administrator on 6/14/2022 5:54:28 PM
This is an Excel feature that is being actively worked on by the Excel team. Updates to follow.