Analyze in Excel Date Columns - Convert Text -> Date

[joaoopsantos]

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!

[Oliver_Ridgill]

Its 2022, planned for 2021. You can't use Analyze in Excel without this.

[ds541y]

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

[takuya_a_abe]

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

[gzavela]

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.

[svbbio]

Is there an update for this fix, please?

[nishalit]

This is an Excel feature that is being actively worked on by the Excel team. Updates to follow.

[daniel_pearce]

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.

[Armin_Kamfirooz]

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

[rhudson]

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

[Yun_Church1]

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.