Skip to main content

Power BI

New

Option to not load un-used columns

Vote (3) Share
Gabriel Grünberg's profile image

Gabriel Grünberg on 27 Sep 2018 15:57:56

This might seem a bit lazy, but often I use tables with a lot of columns which in the end are not used in the report.

I could manually go through each column in every table in a report and check if I use it anywhere. But it would be amazing if PowerBI had a feature to help to "disable loading all columns not being used in the report".

As in any column not used for filters of any kind, or used in any visual in the report.

Preferably this would mean "disable" and not "remove" a column from a table. So you could still see it in the Query Editor preview, but be greyed out in the same way as when you disable a table from loading.