required columns in data model

[powerbiexpert22]

i should keep only required columns in data model considering best practices. should i keep only required column in power query or i should load all columns of table in power query and then remove unnecessary in data model?

[Anonymous · Accepted solution]

Hi @powerbiexpert22 ,

Based on the description, it is recommended to perform data cleaning and transformation in power query before loading the data into the data model.

You can view the following document to learn more information.

Best practice rules to improve your model’s performance | Microsoft Power BI Blog | Microsoft ...

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AlperenA]

I think you can remove unnecessary columns through Power Query.