Improve data model

[bboy0009]

Hi guys,

I just took a report which has a lots of tables and thousand of relationship. I wonder how could I improve that but don't know where to start ?

Do you have some tips ? a process to follow or an article to advice me ?

Thank you in advance!

[v-jialluo-msft]

^{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.}

[bboy0009]

@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 ?

[amitchandak]

@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-Rel...
https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-My-Power-BI-report-is-slow-What-sho...
https://community.powerbi.com/t5/MBAS-Gallery/Aggregation-and-composite-model-Microsoft-Power-BI-fas...