Forum Discussion
Expression error with data query
millerboyz I definitely think it had something to do with the link to the google sheet. Now it works for me too. Of course, I already crated a NEW google sheet and new spreadsheet to get it to work, but now when I go back to the old ones they work. How crazy is that. What gets me though is why it didn't just "say" that the problem was with some sort of connection/permissions issue, but instead gave the error alluding to a column issue. Anyway - thanks to all who helped with this one. As much as I'm a bit peeved at google right now, I couldn't do my job with out them, so will just have to chalk it up to a learning exprerience!
- I'm also flustered over the same problem. Google is constantly creating these updates from sheets that shouldn't be interfering with excel
- I have the same problem, I can get it to show all of the data and even copy it to another page but when I try and get the data I can see to download it states permission issues. I have full access and I cant see any documentation in any of my books on Query that I have bought. (Im just learning it- love Excel and formulas but new to Query)
If there is the problem with permission or like, Google returns you not the document but some page which informs you can't access the file or like.
Excel has no idea about that, it takes the page returned by Google assuming that is your document, and tries to transform it into table. First error appears is the lack or Symbol column, that's how your script is built. It returns that error and stops.
You may handle such errors, but that will require more serious effort in Power Query script building with coding on M-script.
