Column not found in table

[chrisdogg81]

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.

[Anonymous]

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

https://www.antaresanalytics.net/post/2018/08/13/data-management-m-scripting-preventing-the-column-o...

https://answers.microsoft.com/en-us/msoffice/forum/all/expressionerror-column-of-the-table-not-found...

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.

[lbendlin]

Start over, and instead of Table.RemoveColumns() use Table.SelectColumns.  Same result but much more robust.