Data source error: Expression. Error: The column wasn't found

Hi NBHANE ,

Thank you for reaching out to the Microsoft Community Forum.

 

Please follow below steps:

1. Check the column name carefully in SharePoint: Open the SharePoint list. Go to List Settings (gear icon ➔ List Settings). Look under Columns.

Find the internal name of the column: Click on the column. Look at the URL — there will be something like &Field=NameFacilitatingEvent. This internal name must match what Power BI expects. If the name changed slightly, you'll have to update your query in Power BI.

2. Open Power BI ➔ Transform Data ➔ Find the Step that Fails: In Power BI Desktop, go to Transform Data (Power Query Editor). Step through each Applied Step on the right side. Find where the error starts (you'll probably see the red error on the "Navigation" or "Removed Other Columns" or "Renamed Columns" step). If you spot a reference to 'Name facilitating the event', it might need: Updated to the new column name, OR Deleted/adjusted if the column no longer exists.

3. Fix the M Query : You might have M code that looks like:

#"Renamed Columns" = Table.RenameColumns(#"Previous Step", {{"Old Column Name", "New Column Name"}})
or

#"Removed Other Columns" = Table.SelectColumns(#"Previous Step", {"Name facilitating the event", "Other Columns"})
If "Name facilitating the event" no longer exists, you either: Update the M code to reflect the correct name Or remove that column from the list of selected columns.

4. Refresh Data Preview: After adjusting, click Close & Apply in Power BI. Try to refresh again.

If the Column is Missing Completely? If the column is totally gone from SharePoint (maybe someone deleted it by accident):
You might need to re-add the column to the list (with exactly the same internal name). Or adjust your reports to not depend on it.

Note: Even if you see the column visually in SharePoint, Power BI depends on the internal name — not the display name. If the internal name changed, Power BI treats it like a missing column.

 

Can you please refer community threads.

Solved: Expression.Error: The column 'Column1' of the tabl... - Microsoft Fabric Community

Solved: The column " of the table wasn't found - Microsoft Fabric Community

Solved: How do I fix: "Expression.Error: The column 'Displ... - Microsoft Fabric Community

Solved: Error: The column 'xxx' of the table wasn't found.... - Microsoft Fabric Community

Solved: Expression.Error: "The column of the table wasn't ... - Microsoft Fabric Community

Expression.Error: Column ' ' of the table not found. Trying to refresh - Microsoft Community

 

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank you