Forum Discussion
Large Dataset performance issues and system getting freeze
Greetings to all the experts in Power BI! I hope this message finds you well. Currently, I am working on a Power BI project with a large dataset that exceeds 4GB. Two of the tables, after cleansi...
ppm1
Solution Sage
Solution SageA few things to consider:
- make sure there is no more you can to reduce the size of the model. remove any columns you don't need and avoid any high cardinality columns (e.g., datetime, ID on fact tables).
- make sure auto datetime is turned off in the model
- use a star schema (you mentioned two fact tables, so want to confirm)
- see this video on how to troubleshoot the performance of a Power BI visual (and the video related to that one on how to fix it)
Pat