Skip to main content

Power BI

New

Analyze in Excel Date Columns - Convert Text -> Date

Vote (31) 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!