Forum Discussion
Remove columns in source data Excel file
Hi everyone, I am new to Power BI desktop. Problem: The source data is from an Excel spreadsheet. I made a dashboard then deleted one column named 'test column' in Excel and refresh the dashboard,...
Yes, if you remove that last step that you have in the red box, then it won't try to delete a nonexistent column.
Thanks for your idea.
Yes. I want Power BI desktop to just load in whatever is in the Excel file.
simply remove the last step that tries to delete column(s) (and any other steps that reference that column).
Do you mean delete this step marked with red box? please refer to the screenshot.
And delete fieds in the dashboard that reference that column.
Yes, if you remove that last step that you have in the red box, then it won't try to delete a nonexistent column.