"SOLVED" [expression.error] the column 'Symbol' was not found

**steveal** · 11-18-2020, 10:16 AM

After years of using a worksheet which sends a Query to get data from a Google sheet, today it no longer works.

The error is shown above, however the 'Symbol' column is present in both the source and destination worksheets (spelt the same, no spaces).

On accessing the Power Query Editor, I find this in the Advanced editor:

Please Login or Register  to view this content.

Note that the missing column header 'Symbol' appears in both the #"Changed Type" group and the #"Replaced Value" group
Can anyone tell me the meaning of Replacer.ReplaceText,{"Symbol"}. It seems to be replacing the column heading 'Symbol' with nothing?
If this is the problem, How can I get rid of that expression?

Please Login or Register  to view this content.

**rorya** · 11-18-2020, 10:24 AM

I suspect there's something wrong with your link. Do you see the column headers when you select the Source step of your query in the query editor?

**AliGW** · 11-18-2020, 10:27 AM

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

**CK76** · 11-18-2020, 10:28 AM

Removed, See post above by Ali.

**steveal** · 11-18-2020, 11:02 AM

Apologies, I hope I've made the necessary changes above [not an area I'm familiar with].

**AliGW** · 11-18-2020, 11:03 AM

Thank you.

**steveal** · 11-18-2020, 11:05 AM

Originally Posted by rorya

I suspect there's something wrong with your link. Do you see the column headers when you select the Source step of your query in the query editor?

Initially, I did have the column headings there. Now, the columns are full of 'descriptions' like <!DOCTYPE html>. How can I fix the link?

**CK76** · 11-18-2020, 11:10 AM

Do you have the permission on the document? I'd wager that you are querying redirected HTML page.
Try testing by using link directly in your browser. If it doesn't immediately start CSV download, that's your issue.

Also, I'd recommend removing ", Columns=9" from your Csv.Document. While this will improve performance in certain cases, it will break your query when data structure (# of columns) changes in source.
This argument is optional and isn't needed.

**steveal** · 11-18-2020, 11:20 AM

Originally Posted by CK76

Do you have the permission on the document? I'd wager that you are querying redirected HTML page.
Try testing by using link directly in your browser. If it doesn't immediately start CSV download, that's your issue.

Also, I'd recommend removing ", Columns=9" from your Csv.Document. While this will improve performance in certain cases, it will break your query when data structure (# of columns) changes in source.
This argument is optional and isn't needed.

If I click on Data/Show Queries in Excel and then hover over the query in the right pane, I can copy the Data Source URL and put that in a browser tab. The relevant Google sheet opens with correct up to date data. Is that what you meant?

**CK76** · 11-18-2020, 11:30 AM

No it should not open in browser, but it should start csv download.

**steveal** · 11-18-2020, 12:14 PM

OK. I've been and made a fresh link.
- I (re)published the Google sheet to the web as a .csv file
- I made a new query in Excel to import the .csv file
It works!

I'm sure this isn't the best way to get this data into Excel - but it was 3 or 4 years ago when I made this worksheet following guidance online.

Thanks for all your help. The guide to the link problem was the crucial part.

"SOLVED" [expression.error] the column 'Symbol' was not found

LinkBack

Thread Tools

Rate This Thread

Display

"SOLVED" [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Re: [expression.error] the column 'Symbol' was not found

Thread Information

Users Browsing this Thread

Similar Threads

How to Ignore error [Expression.Error]The column 'Stock' of the table wasn't found

Get Data from Folder Function Error [Expression.Error]

[SOLVED] Runtime Error '3075': Syntax error in the string in the query expression [SQL]

[SOLVED] Search returns column header or error if value not found

[SOLVED] Compile error: Constant expression required error when merging two Codes

[SOLVED] Compile Error: Expected Expression, Syntax Error

VBA compilation error : expected expression error

Bookmarks

Bookmarks

Posting Permissions