Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
FarmingBA
Helper I
Helper I

Expression.Error: "The column of the table wasn't found." despite making no changes to source file

Hi all,

 

The data-source for my report is an Excel spreadsheet. I have been updating values in the spreadsheet and refreshing the data with no issue for about three weeks. Now, I am getting an error message: (snip also included).

 

Expression.Error: The column 'Project' of the table wasn't found.
Details:
Project

 

This is strange because I haven't changed the source data columns at all. I have changed none of the column names, or added new columns. When I look at an older version (two weeks ago) of the data-source, everything is exactly the same. All that has changed is a few cells values have changed.

 

FarmingBA_1-1679956828126.png

 

I have looked at previous threads with the issue, and most are down to a column in the source data changing. Therefore a solution can be found by changing the source data back. However, this is not available to me as there has been no discernable change since when the report was working.

 

I would be grateful for any help. Happy to provide more info,

 

Thanks,

Farming BA

1 ACCEPTED SOLUTION
HotChilli
Super User
Super User

In the first column, the row with Project on it is in the 3rd row after the 'Promote first row to headers'.

Presumably at that point in previous weeks, it would be in the header.  So that's the problem.

In the step that shows an error, there is no Project column, hence the error. At that stage it's called Column1.

Either the data format has changed or the query steps have changed from a working solution.

--

So you can edit the query steps or re-examine the source and see where the problem is (extra rows have been added, it looks like)

 

View solution in original post

4 REPLIES 4
HotChilli
Super User
Super User

In the first column, the row with Project on it is in the 3rd row after the 'Promote first row to headers'.

Presumably at that point in previous weeks, it would be in the header.  So that's the problem.

In the step that shows an error, there is no Project column, hence the error. At that stage it's called Column1.

Either the data format has changed or the query steps have changed from a working solution.

--

So you can edit the query steps or re-examine the source and see where the problem is (extra rows have been added, it looks like)

 

This has been very helpful. I edited the query steps to ensure that the correct row was promoted to headers and this resolved the issue. 

 

Many thanks!

FarmingBA
Helper I
Helper I

Thank you for the response. When I go one step back from the error, then I can see that the project column is present. The step I took before the error was to Promote Rows to Headers. The error then appears from that step onwards. 

 

Does this shed any further light? As I said, this has not caused an issue for several weeks until today.

 

FarmingBA_1-1679964850287.png

 

 

HotChilli
Super User
Super User

Difficult to say with limited info.

You will have to investigate the Previous Steps to the error step and see if something has happened to the Project column.

First of all, look at one step previous and see if the Project column is present.  If not, check back through the steps to the first and see what happened to it.

Will help if you can provide more info after investigation

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.