Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hello,
I am using Power BI 32 bit version as the whole team using Power BI are having Microsoft Office 32 bit. I have created a report which has a few data and I am performing in DAX a UNION function which has SELECTCOLUMN functions in it. This seems to take a lot of RAM as when I am trying to open the Power BI file it returns an error message " Exception of type "System.OutOfMemoryException" was thrown".
Can you please suggest some ways to solve this issue (i.e ways on how to decrease the memory requirements for the report or any other potential solutions)?
Many thanks!
Hi @Anonymous ,
I'd like to suggest you to use 64 bit version, it allow you to use more memory resource on power bi desktop.(32bit applications has 2G memory limit: Memory Limits for Windows and Windows Server Releases)
Regards,
Xiaoxin Shenge
Hello Xiaoxin,
Many thanks for your support, I understand that the 64 bit version is the ideal solution. However, as I mentioned it is not possible to replace Office 32 bit to 64 bit for all Power BI potential users for multiple reasons and I am trying to thing ways to resolve this issue with other ways. Is there anything else you can suggest (i.e. ways to minimize report specs etc.)?
Many thanks,
Marios
Hey Tom,
Many thanks for your suggestions, they useful to start thinking about new ways to resolve my issue. Unfortunately in my client's laptop I need to download Access Database Engine in order to refresh Power BI reports from my excel data. When I go to download Access Database for 64 bit I have a conflict with Microsoft Office as I get error message that I cannot download Access Database for 64 bit while having Office 32 bit. This issue gives me no option than to go for Power BI 32 bit version with which I am having the issue with System out of memory exception. Please note that I do not have the option to use Office 64 bit for multiple reasons.
About using Power Query to append my tables I am afraid I cannot use this as I am having some essential DAX calculated fields in my tables which dissapear when I go to Query editor. For that reason I am using the functions UNION and SELECTCOLUMNS in DAX.
Looking forward for your response.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
87 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
127 | |
109 | |
93 | |
70 | |
67 |