Hi there,
I have a table created from Power query in excel - which I have created numerous pivot charts from
On my source data a column was removed. Now i am receiving an error that my data cannot refresh as that column was not found
"Expression.Error: The column 'column x' of the table wasn't found.
Details:
Column x"
Can some help me. I was tempted to just start again and Power query my data again, but don't want to have to recreate my pivot tables
You need to work through the query and remove any reference to that column in each step.
Post the M code (copy paste from the advanced editor window), tell us the column name and we can help you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks