Power BI

Planned

Analyze in Excel Date Columns - Convert Text -> Date

Vote (285)

Power BI User on 05 May 2020 19:40:38

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!

Administrator on 14 Jun 2022 17:54:28

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

Comments (40)

Comments (40)

Chris Roberts on 20 Jan 2022 10:18:03

RE: Analyze in Excel Date Columns - Convert Text -> Date

Is this still happening?

Tom Munson on 13 Jan 2022 20:58:10

RE: Analyze in Excel Date Columns - Convert Text -> Date

wow, add me to the comments come on Power BI team.... Please fix :-)

Ole Østlid on 09 Jan 2022 22:17:48

RE: Analyze in Excel Date Columns - Convert Text -> Date

Has this update been postponed?

PLANNED 2021 RELEASE WAVE 2

Nick Lor on 10 Dec 2021 18:58:08

RE: Analyze in Excel Date Columns - Convert Text -> Date

Need this ASAP. Working with a model with 4-5 Date Tables and will have to manually add in hierarchies for each.

Neil Bank on 11 Nov 2021 15:30:01

RE: Analyze in Excel Date Columns - Convert Text -> Date

This is really really bad..

Michael Martini on 25 Oct 2021 08:04:04

RE: Analyze in Excel Date Columns - Convert Text -> Date

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.

Mateusz Masior on 23 Sep 2021 11:12:35

RE: Analyze in Excel Date Columns - Convert Text -> Date

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.

Viktor Janssen on 12 Sep 2021 08:21:29

RE: Analyze in Excel Date Columns - Convert Text -> Date

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.

Bill Balnaves on 09 Sep 2021 01:11:08

RE: Analyze in Excel Date Columns - Convert Text -> Date

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])

Andrew Sinha on 16 Jul 2021 12:24:31

RE: Analyze in Excel Date Columns - Convert Text -> Date

This will be good. Thanks again Andrew