Skip to main content

    Power BI

    Planned

    Analyze in Excel Date Columns - Convert Text -> Date

    Vote (287) 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

    Rick Trask on 28 Sep 2020 20:58:58

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

    After all these years this is still out here, WOW. Why is it so hard to understand that without the ability to group the date in the Pivot Table, the connector is essentially worthless for most use cases? I will keep on using the Excel data connector options directly to the data source to get proper data formats.