Forum Discussion
Remove empty columns - filesize issue
Hi everyone, I need to clean up a powerbi that consists of many different source files (excel/csv). Some of these source files contains many columns and I am trying to remove the empty ones auto...
Could it be because the "formula" is looping through all columns to determine if it's empty or not? Using the file size multiple times?
Of course one of the solutions might be to remove them manually, but the goal is to have them appear should there be any input at one point in time.
By the way, I finally opted for manual removal anyway .... the formula took way too much time and it was in the end more efficient manually