Improve data model

bboy0009 , If you know some fact table or dimension table start with that.

Add a new tab in the model view, add one table and check for the related tables (option on three dots of the tables)

Try avoid di-directional relationship, many to many join etc

Best Practices
https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-The-Do-s-and-Don-ts-of-Power-BI-Relationships/td-p/712566
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-should-I-do/td-p/712567
https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fast-and/td-p/712871

amitchandak 

Hello

I didn't understand that point "Add a new tab in the model view, add one table and check for the related tables (option on three dots of the tables)"

Can you explain ?

^{Hi bboy0009 ,}

^{Try cleaning and transforming your data according to the exercises below, which contains some tips for working with data.}

^{If this is not what you need, please indicate the specific question.}

Clean, transform, and load data in Power BI - Training | Microsoft Learn

^{Best Regards,}

^{Gallen Luo}

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