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...
You must edit the data source of the pivot table and this should open the Power Query pane. Here you must set the correct data types for all columns.