Forum Discussion
Expression error with data query
Hi, I have a table of data that is connected to my excel sheet through a query. When I try to refresh the table, I get this message: [expression error]. The column "calendar" of the table wasn't ...
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.
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)