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 :)
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 :)
I tried clearing the cache- clearing all permissions and refreshed. It doesn't seem to work. What am I missing?
Thank you!
HI Johalien
I tried cearing credentials and I have the same problem still. Its just an excel spreadsheet.
Luis