SSAS + Query folding + change type to datetime

The best solution probably is changing the date column in the cube itself to the appropriate data type.

I doubt it's possible to change the type without breaking query folding (though I'd be happy to be proven wrong).

Hi ivostammis ,

According to my test,  not all changes in data types will break query folding.

For example:

• Datetime -> Text  and Whole Number to Text , both were possible and would not break query-folding:

• But Text type -> DateTime or Date would break query-folding.

For more information, please refer to:

Changing data types that do not break query-folding in Power Query / Power BI

So as you and AlexisOlson mentioned, you need to contact the admin of the SSAS to change the type.

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.