The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi there,
Keep getting the same error messages:
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The column 'X' of the table wasn't found.. '.
Query parameters Parameter4 Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The column 'X' of the table wasn't found.. '.
I've been struggling with this error for the whole day! Look through all the files in the folder, all column names (header) match in all of them. Tab names are all the same. Cleared cache etc, but still can't fix the problem.
I'd be grateful if you can shed any light on this. Thank you.
best wishes,
See Mun
Solved! Go to Solution.
Please check in your source data file, deleted one column
Due to that your getting that error
Posting this in case it helps someone else in a similar situation. I had this error when loading a group of json files from a SharePoint folder. The issue turned out to be that one of my 50+ files was empty, so there indeed was no column, but just in that one file. Troubleshooting that was a real head-scratcher. I ended up creating another folder and copying just a few of the files into it and loading that worked perfectly. So I had to narrow it down to the bad file essentially by process of elimination. In hindsight, I could have also looked at the file sizes to figure out one was empty.
Tnks a lot! I had exactly the same issue, that was kindda weird for me having a Sharepoint datasource but geting a OLE ODBC error. Tnks
It works! Thank you!
S
Please check in your source data file, deleted one column
Due to that your getting that error
User | Count |
---|---|
77 | |
77 | |
36 | |
30 | |
28 |
User | Count |
---|---|
106 | |
97 | |
55 | |
49 | |
46 |