Forum Discussion
Solved
Insufficient memory
Good afternoon, I ask for your help, I have the following error: "There is not enough memory to complete this operation." This error comes out when integrating the following function into a tab...
Hi Joswin_100
Please kindly refer to the blog to fix the issue:
https://thegeekpage.com/fixed-there-is-not-enough-memory-to-complete-this-operation/
Besides,To debug this do the following:
- Download and install Dax Studio http://daxstudio.org/
- In you Power BI report create a blank report page and save the desktop file with this page open/selected
- Close All Power BI desktop sessions
- Start Power BI desktop again and open only this report LEAVE IT on the blank page!
- Start DAX Studio and connect it to the Power BI Desktop file you have issues
- In DAX Studio click the ALL Queries button
- Wait until output windows shows
- Now go to Power BI and start doing what you do while you are getting the memory error...
- When you have it return to DAX Studio and see what is on the All Queries page of your query trace…
- Find your longest running queries and analyze them…
But when filtering a product, the function runs well (image annex)
In the salt table, the "buy $" column makes me the multiplication line by liea and the total makes me the sum of all the rows.
The buy order table, I leave it comp reference, basically in this table I get the average price of the last purchases