Skip to main content
Microsoft Idea

    Power BI

    Planned

    Analyze in Excel Date Columns - Convert Text -> Date

    Vote (281) Share
    Power BI User's profile image

    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 (41)
    Power BI User's profile image Profile Picture

    Oliver Ridgill on 09 Feb 2022 15:06:12

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

    Its 2022, planned for 2021. You can't use Analyze in Excel without this.

    Power BI User's profile image Profile Picture

    Chris Roberts on 20 Jan 2022 10:18:03

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

    Is this still happening?

    Power BI User's profile image Profile Picture

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

    Power BI User's profile image Profile Picture

    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

    Power BI User's profile image Profile Picture

    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.

    Power BI User's profile image Profile Picture

    Neil Bank on 11 Nov 2021 15:30:01

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

    This is really really bad..

    Power BI User's profile image Profile Picture

    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.

    Power BI User's profile image Profile Picture

    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.

    Power BI User's profile image Profile Picture

    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.

    Power BI User's profile image Profile Picture

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