Forum Discussion
Removing any columns causes errors
I think I figured it out - might be related to the credentials to access the data source.
I cleared my cache - went to "data source settings" and cleared all permissions - then recaptured them.
I was able to load this source again and make all changes necessary.
Anonymous - thank you for your assistance :)
Can you provide a screenshot of the error and the step before the error step? I will try my best to debug it
Steps before I get the errorStep Causing the errorAdvanced EditorError after I apply changes
Did you check if your Excel file has Column1 or maybe there is an extra space after Column1 like "Column1 "?
Hi
Power Bi adds two additional columns to the left. One is blank and the other is an index column. But the error is not column specific. If i remove 5 columns it will continue to give me the error until I add them all back.
I am getting this error when I apply any changes now and also on all my data sets looking at google sheets :smileysad:
I think I figured it out - might be related to the credentials to access the data source.
I cleared my cache - went to "data source settings" and cleared all permissions - then recaptured them.
I was able to load this source again and make all changes necessary.
Anonymous - thank you for your assistance :)