Error when refreshing in desktop

[Sohan]

I have changed my file sources from .xslx to .csv. When I try to refresh the data, I get the following error message for all tables that I have changed the data source for:

Failed to save modifications to the server. Error returned: 'The column 'Week' specified in the 'GROUPBY' function was not found in the input table. An unexpected error occurred (file 'tmtransaction.cpp', line 6019, function 'TMTransaction::InferTypesForCalcPartition').

Does anyone have an idea how I can resolve this? All the tables are identical. The only that's changed is the source.

[v-rongtiep-msft]

Hi  @Sohan ,

It seems that there is something wrong with the cloumn 'week'. Please try to open Power Query Advanced Editor to find the relevant fields and check the error.

Best Regards

Community Support Team _ Polly

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

[lbendlin]

Power Query is case sensitive. Also check for extra spaces etc.