Forum Discussion
Importing data into pivot excel from SSAS Tabular, wrong data type
Excel does not convert the data to PivotTable as I expect, columns that are Date type are treated as Text, which prevents me from additional column filtering (by date functions), has anyone encounter...
That's good practice to ensure all fields data types are declared to final step in Power Query. Otherwise that could be issues like this plus you could slightly improve performance. And that's not a bug, that's by design - data model has no idea what do we assume using "any" data type, treats all such fields as texts.