Removing any columns causes errors

[Johalien]

Hi

My source data is from a google sheet. It has not changed in any way - I have been working on it for the last month.

However, suddenly I am getting errors.

Today I re-imported the source and noted that as soon as I remove columns I get the following error:

"The column of the table wasn't found"

It does not matter which column I remove. I will continue to get that error until I added all removed columns back.

Yes, I updated gateway. Yes, I checked the advanced editor. Yes, I checked the types. No, I did not add any customer columns. The ONLY thing causing this error is when I remove a column. I even made sure to make not changes except removing columns (Applied steps shows Source / Navigation / Removed Columns. Am I missing a hidden setting that I might have accidentally activated?

Johalien

[Anonymous]

@Johalien,

Sometimes when I use Excel file as a source, I would get additional null columns. To prevent this, you can use Remove Other Columns to keep the columns you want instead of removing the columns you dont need. 

[Johalien]

Hi Nick

Thanks for the tip. Unfortunately I am still getting the error.

[Anonymous]

@Johalien,

Can you provide a screenshot of the error and the step before the error step? I will try my best to debug it

[Johalien]

Steps before I get the errorStep Causing the errorAdvanced EditorError after I apply changes

[Anonymous]

@Johalien,

Did you check if your Excel file has Column1 or maybe there is an extra space after Column1 like "Column1 "? 

[Johalien]

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 

[Johalien · Accepted solution]

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 🙂

[hernandez_nj]

HI Johalien

I tried cearing credentials and I have the same problem still. Its just an excel spreadsheet.

Luis

[Anonymous]

I tried clearing the cache- clearing all permissions and refreshed. It doesn't seem to work. What am I missing?

Thank you!