206
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!
STATUS DETAILS
Planned
2022 Release Wave 2

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

Comments

P

Is there an update for this fix, please?

P

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.

P

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

P

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

P

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

P

Is this still happening?

P

wow, add me to the comments come on Power BI team.... Please fix :-)

P

Has this update been postponed?

PLANNED 2021 RELEASE WAVE 2

P

Need this ASAP. Working with a model with 4-5 Date Tables and will have to manually add in hierarchies for each.

P

This is really really bad..