Skip to main content
Microsoft Idea

Power BI

Planned

Analyze in Excel Date Columns - Convert Text -> Date

Vote (282) 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.