Only import used columns

[mandar]

Hi,

In few of our reports we have used select * to pull all the columns from the views and as you can imagine its not gone too well with the client.

Is there a way I can easily identify the columns that are actually used in the PBI report, and then only import those from the database.

(I am aware of the tool 'measure killer' which is a great tool, but unfortunetly that only removes the columns AFTER  they are imported in the report)

Also note that there are instances we are using a shared dataset and also single dataset single reports.

Thanks!

[Brunner_BI]

@mandar you can use external tools like our Measure Killer to find what is used in the report or in relationships etc. and what is not.

[lbendlin · Accepted solution]

There is no exact process behind this. The moment you remove a column a business user will call you and ask where that column went.

Your tables should be long and narrow. If they are then you should be able to load all (or most) columns to be prepared for changes in business requirements.