How can I reduce load times in my Power BI Report

[Anonymous]

Hi all,

I am making a report that contains company data from 2018, but once I put the 2019 dataset in as seperate tables from the 2018, the report suffered from extreme amounts of load times when the client tries to filter the data, and visuals in the reports page can take up to two minutes to load. Each table contains roughly 80,000 rows and about 30 columns. If I combined the 2018 tables and 2019 tables into one larger table, will this help reduce load times? Or are there other ways I can fix this problem, as I would like to add 2020 and 2021 data in the future, and those tables will be of similar size.

Thanks in advance

[amitchandak]

@Anonymous , This does seem like big number. Hope you are using star schema. Avoid bi-directional joins

also refer

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

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