Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
Power Query is case sensitive. Also check for extra spaces etc.
User | Count |
---|---|
93 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |