Power BI 32 bit version - Exception of type "System.OutOfMemoryException" was thrown

[Anonymous]

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!

[v-shex-msft]

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

[Anonymous]

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

[TomMartens]

Hey,

you can use Power BI 64bit also if you have Office 32bit, this matters only if you use Access as a data source.

You may consider to combine the tables in Power Query using the APPEND transformation and just use the new table in your model.

Maybe this gets you some ideas.

Regards,
Tom

[Anonymous]

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.