error The 'Title' column does not exist in the rowset.

[Shama987]

Hi All,

i have a dashboard with multiple sharepoint lists as source and i have made updates to power query to manage the empty lists if any. 

however, when one of the list is empty and the refresh happens in service, the report fails to refresh and gives error  "The 'Title' Column does not exist'. In desktop, it is refreshing completely without any error.

how to delete this column when table is empty?

[V-pazhen-msft]

@Shama987 
Please refer to the m code in the solution and discussion in this post:
Solved: The 'HasUniqueRoleAssignments' column does not exi... - Microsoft Power BI Community

Paul Zheng _ Community Support Team

[Shama987]

Any idea how to add this as a sub query to if statement? 

if sharepoint data empty, then create row will id as null,

and then the next step create subquery to remove column,

else, go to next step.