Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.