Power BI

Planned

Analyze in Excel Date Columns - Convert Text -> Date

Vote (282)

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 (39)

Comments (39)

Curtis Stallings on 28 Apr 2021 14:38:35

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

Getting a bit ridiculous having to wait this long. I agree makes analyzing in excel obsolete.

Stephen Costanzo on 29 Mar 2021 17:27:01

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

Why is this even a voting issue??? I mean, I can deal with the fact I have to use measures for values. But it's a Microsoft to Microsoft product, why isn't the date passed.

At least if I could connect to the source in the power query section of excel I could reformat.

Andrew M on 19 Mar 2021 06:04:44

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

There are a few other requests for the same thing.
This issue makes the analyze in excel rather difficult to use

Gui Vendemiatti on 18 Feb 2021 15:26:25

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

This needs to be addressed!!!

Cedric CHABERT on 02 Feb 2021 11:53:09

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

How can this not be posible? what's the point of ANY analysis if you can not have a clear date filter? Come on this can not be in a "need votes" status it is just a BASIC functionnality

Adam Canale on 26 Jan 2021 20:24:11

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

PLEASE ADDRESS THIS!!!

Ross Nelson on 31 Dec 2020 21:45:10

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

Still not fixed? I can't imagine this would be a huge undertaking for devs to resolve.

Guido Lenzi on 30 Sep 2020 23:32:57

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

My god .... this is really said... it is hard to see some Microsoft areas working on big things, bringing so good products but in the other hand other with really basic problems that cause this much impact on a software. until today no one looked at this... this is common problem of a bureaucratic process of listening to client demands through a single channel and plastered process classifying tall in the same bucket

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.