Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I'm geting memmory Allocation Failure om Power Bi Desktop.
I have removed as many columns as i could but fail to change a date format or even add a column to my report/dashboard.
Any help would be appreciated.
Thanks
get more space in C: drive
or
Try to clean the data load cache: File -> Options and Settings -> Options -> Data Load -> Clear cache and Save the file and Load again
Hi, @Raj_j
Could you check if the file size exceeds 1GB?
Or when it is refreshing the data because of too many queries it is running out memory?
Some basic steps that usually work are:
Calculated (dax) columns are not compressed as well as computed (power query) columns. You could try and add your columns in power query instead.
Here are more references that may be helpful:
Memory error: Memory Allocation failure
Memory Allocation failure . Try simplifying or reducing the number of Queries
Memory error: Memory Allocation failure . Try simplifying or reducing the number of queries
FIX: Power BI Memory error allocation failure
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi and Thnaks for your response.
I'm not sure on the size of the data as it's coming straight from the database.
I have adjusted my pagefile size to 16gb and Data Load to 2K and i still get the error.
I am running Power Bi 32 bit version as i couldn;t get my ingres odbc connection working for the 64 bit
Thanks
@Raj_j You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Thanks for you response.
I checked out your first solution before posting but thank you.
For the second solution, it won't let me create a ticket as we are licensed for Microsoft products by a reseller so our Admins are logging it on my behalf.
Thank you
User | Count |
---|---|
81 | |
76 | |
62 | |
60 | |
48 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |