Forum Discussion
Column not found in table
I need HELP!
I have a Power BI file that's connected to a SharePoint List. I created 4 items in the list so that I could start creating visuals in Power BI. The entries were basically dummy data. Yesterday I delete the 4 entries that I created in the List. When I went to refresh the .pbix file I'm now getting the error message:
"The column 'FileSystemObjectType' of the table wasn't found."
I have no clue what went wrong. I did not change anything about the SharePoint List, other than delete the entries, and I did not make any changes to the Power BI file. I really do not want to recreate everything from scratch so any assistance would be greatly appreciated.
I've added some screenshots to give a better idea of what's going on.
When I try to refresh I get this error:
When I go "Transform Data" to check out my tables the main table displays this:
When I go to "Advanced Editor" this is what I see (FileSystemObjectType is underlined in green):
The other two tables with errors displays the message below.
I'm going to continue looking around the forums for an answer. Again, any help is much appreciated.
2 Replies
- lbendlinSuper User
Start over, and instead of Table.RemoveColumns() use Table.SelectColumns. Same result but much more robust.
- AnonymousNot applicable
Hi chrisdogg81 ,
This is the related document, you can view this content:
https://community.powerbi.com/t5/Desktop/The-column-quot-of-the-table-wasn-t-found/m-p/414717
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.