Skip to main content

    Power BI

    Planned

    Analyze in Excel Date Columns - Convert Text -> Date

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

    Gareth Mueller on 04 Apr 2023 09:13:52

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

    Wondering when this will be implemented?

    Power BI User's profile image Profile Picture

    Yun Church on 02 Apr 2023 20:21:03

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

    Not sure where this is in terms of priority for Microsoft but the lack of this functionality is essentially giving my team minus advantage in convincing our infra team to switch from Tableau to Power BI at enterprise level. I really hope they are making progress on this and will be releasing it soon.

    Power BI User's profile image Profile Picture

    Rob Hudson on 14 Nov 2022 02:57:01

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

    Adding my endorsement for this as a *need*.We had to build a date table that we joined in, with all of the heirarchy values... but this is pretty inefficient, more than a little ugly, and requires maintenance

    Power BI User's profile image Profile Picture

    Armin Kamfiroozie on 20 Sep 2022 17:20:16

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

    I can't believe this issue has not fixed after at least 3 years!! Any solution or alternative on this?

    Power BI User's profile image Profile Picture

    Daniel Pearce on 11 Jul 2022 10:48:03

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

    We struggled with this problem for a good few months. Using a Dataflow solved all our problems. You can pull date directly into PowerQuery, and all datatypes come in with the expected format.

    Power BI User's profile image Profile Picture

    Anna vb on 13 May 2022 18:58:03

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

    Is there an update for this fix, please?

    Power BI User's profile image Profile Picture

    Greg Z on 06 Apr 2022 18:53:28

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

    It seems like there is still zero response from the Power BI employees. Can we get a confirmation as to when this is going to be implemented? Our executives and leadership team has stated that the analyze in Excel solution in it's current state is unacceptable.

    Power BI User's profile image Profile Picture

    Takuya A. Abe on 03 Mar 2022 00:56:18

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

    Seems this is still occuring. Please fix....

    Power BI User's profile image Profile Picture

    DAVE SCHOENFELD on 09 Feb 2022 18:25:18

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

    Just echoing other's comments that without this being fixed, using Analyze in Excel is virtually worthless for most scenarios within the reporting world.

    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.