Forum Discussion
Can't find column on Refresh
Anonymous Can you post at least the start of your query using Advanced Editor? Perhaps someone inserted a column in the Excel spreadsheet and depending on how the code is written perhaps you are now not grabbing that column initially?
Thanks to Greg's insight, I was able to fix this by using the Advanced Editor and deleting the "#(lf)" from the name of the column that was presenting error in all steps in which it appears.
I was not familiar with this function nor with the M language tha PBI uses to create the tables. Good learning experience.Best and Stay safe everyone!
Community ChampionAnonymous Can you post at least the start of your query using Advanced Editor? Perhaps someone inserted a column in the Excel spreadsheet and depending on how the code is written perhaps you are now not grabbing that column initially?
Hey there,
I did a little digging on my own and figured what the Advanced Editor is (never used it beffore). Here are some pics of the code and a highlight of the columns presenting the error.
One thing that calls my attention is the "#if" in the middle of the column header. I'm not familiar with the syntax of this code, so couldn't tell what this should mean.
Best,
Thanks to Greg's insight, I was able to fix this by using the Advanced Editor and deleting the "#(lf)" from the name of the column that was presenting error in all steps in which it appears.
I was not familiar with this function nor with the M language tha PBI uses to create the tables. Good learning experience.Best and Stay safe everyone!