Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Empty SharePoint list causes Power BI data refresh to fail

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.

 

Taryn_0-1697489656743.png

 

Taryn_1-1697489656745.png

 

 

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.

Status: Needs Info
Comments
Anonymous
Not applicable

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
Frequent Visitor

Hi @v-yetao1-msft,

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

RamMuddaiah
New Member

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