Forum Discussion
required columns in data model
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?
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 Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
I think you can remove unnecessary columns through Power Query.
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 Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
