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

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.