Forum Discussion
Still receiving memory error after removing columns and simplifying model. DaxStudio looks good.
I am receiving the following error in both Desktop and Service: "Memory error: The memory used for the current operation exceeds the memory limit for the workload group."
I used DAXStudio to identify some issues and took the following actions to clean up my model, drastically reducing it's size and complexity:
- removed unnecessary columns
-removed unnecessary relationships (there are currently no active relationships in my model)
-disabled auto date/time in settings
I am not a premium user but am using a fraction of my storage.
2 Replies
- amitchandak
Super User
Anonymous , Check the size improvements.
Remove date Hierarchy, if needed. (Option, Date/time intelligence - uncheck )
Do you have bi-directional joins? Try to reduce them.
refer if these two can add any values - 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 - Greg_Deckler
Community Champion
Anonymous Is there a specific operation that you are doing that is causing problems like a specific measure or visual? Do you have any many-to-many joins? Perhaps if you posted the size of your dataset, diagnostics info on Desktop version, etc. Pretty vague but looks like you hit a lot of the highlights.
