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

[FarmingBA]

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.

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

[HotChilli]

There's a call out to a yahoo finance website.  It looks like a failure to complete the call or a change in format of the data returned is causing failure.  You will have to try and narrow it down to the specific step.

[HotChilli · Accepted solution]

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)

[Rka82]

I have this same issue as the OP. What was not addressed is the concept of the file working just fine, and then all the suddent failing to work. In my file, it will actually work RANDOMLY on one machine, and NOT work on another machine. Then, it will fail on both. I have been using this file for a couple of years, and the failures seem to come and go. I have tried changing the file in various ways and cannot find ANY solution to make the file work predictably and consistantly. 

Below as well as some screen shots and anyone could easily recreate it on their own. AGAIN, this file has a mind of its own, and works sometimes, and not others. I am losing my mind as to how this can be the case.

the excel view, that used to populate Dividends.1 with amounts and Dividends.2 with "Dividend"a shot of the error and power query viewshot of the 2nd query power in query viewimage of code from Tickers Queryimage of code from DividendHistory Query

[FarmingBA]

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]

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.

[HotChilli]

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