How can i refresh a report when Sharepoint List is empty.

[nitzanr]

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 

[v-yangliu-msft · Accepted 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.

[sevenhills]

https://community.powerbi.com/t5/Desktop/Error-when-SharePoint-list-is-empty/m-p/564396

check the link 

[nitzanr]

Thanks, The WA is from 2018, anyone knows of other solution ?