Schema problem

[Anonymous]

I had prepared the dashboard considering 7 columns and now I have received 6 columns in the input. This is causing an issue in the file input. Can you please suggest me how I can address this issue?

As a temporary solution, I am adding a blank column with the same name to keep it consistent.

[amitchandak]

@Anonymous , if the power query has any transformation(steps) on column 7 (rename, change type), etc then it will error. Remove column 7 from all such steps.

Or what you are doing is fine