Forum Discussion
How can i refresh a report when Sharepoint List is empty.
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
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 foundhttps://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.
3 Replies
sevenhillsSuper User
Thanks, The WA is from 2018, anyone knows of other 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 foundhttps://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.
