Empty SharePoint list causes Power BI data refresh to fail

[Taryn]

When an empty SharePoint list is used as a data source, it fails with the message
Expression.Error: The column 'ID' of the table wasn't found.
Details:
ID

This issue seems tied to the age of the SharePoint list. I created a new list by copying an existing list and it fails on the navigation step (when you choose the table). I get the error immediately when I select the list name.

However, when I create a new blank SharePoint list, I don't have the problem.

If someone could please let me know how we could change the old list to make it work, that would be wonderful. I really don't want to spend hours recreating every list and I don't want to disrupt ongoing activities.

[Anonymous]

Hi  @Taryn 

What if it's an the old list with data ? Do you get an error reported when you connect to that list?

Best Regards,
Community Support Team _ Ailsa Tao

[Taryn]

Hi @v-yetao1-msft,

An old list with data loads fine. It's just the empty list that fails.

[RamMuddaiah]

I am facing same issue after updating data into Sharepoint list.