Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello
I have nightly Job to delete my shapoint list items.
When the list is empty ther efresh fails with this error message " Processing errorThe column 'ID' of the table wasn't found. "
My expectation is that the refresh will run and ill get the correct number of items in the list - Zero.
I assume its a configuration issue and if not do we have a WA for the same ?
Thanks in advance
Solved! Go to Solution.
Hi @nitzanr ,
According to the error message, you might have some steps that reference the column ' ID ' which has been removed or renamed or any other operation when you modified the query. It could be a step where you renamed, re-ordered columns, changed data types, removed other columns, etc.
Directly, right click on your query then select Advanced editor. Here you can see the name of columns/object used for each step of your query, find the unfound column name and edit it.
Here are threads similar to yours, please take a reference:
Expression.Error: The column '<ColumnTitle>' of the table wasn't found
https://community.powerbi.com/t5/Desktop/Data-refresh-with-empty-SharePoint-lists/m-p/101635
https://community.powerbi.com/t5/Desktop/Error-when-SharePoint-list-is-empty/m-p/564396
https://community.powerbi.com/t5/Desktop/Removing-any-columns-causes-errors/m-p/414805#M190415
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @nitzanr ,
According to the error message, you might have some steps that reference the column ' ID ' which has been removed or renamed or any other operation when you modified the query. It could be a step where you renamed, re-ordered columns, changed data types, removed other columns, etc.
Directly, right click on your query then select Advanced editor. Here you can see the name of columns/object used for each step of your query, find the unfound column name and edit it.
Here are threads similar to yours, please take a reference:
Expression.Error: The column '<ColumnTitle>' of the table wasn't found
https://community.powerbi.com/t5/Desktop/Data-refresh-with-empty-SharePoint-lists/m-p/101635
https://community.powerbi.com/t5/Desktop/Error-when-SharePoint-list-is-empty/m-p/564396
https://community.powerbi.com/t5/Desktop/Removing-any-columns-causes-errors/m-p/414805#M190415
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, The WA is from 2018, anyone knows of other solution ?
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.
User | Count |
---|---|
91 | |
84 | |
65 | |
62 | |
58 |
User | Count |
---|---|
150 | |
113 | |
95 | |
80 | |
72 |