Forum Discussion

chrisdogg81's avatar
chrisdogg81
Regular Visitor
4 years ago

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