Power bi desktop 32 bit connection problem

[mohsin-raza]

Hi.

My bi rapport closed itself when i refresh data.

One thing is that i have 32bit powerbi  to connect 32bit odbc .If i used 64bit powerbi i can not access the database .

Therefore i must have 32bit powerbi to connect database.

It work  sometime fine if it just connect to database. Again when  connect with excelfile that  is in sharepoint ,he refresh rate become slow and it close  itself or send msg "SystemOfMemoryException".

How can i solve this problem?  A good suggestion solve my problem so well other having same type of problem

regards

[amitchandak]

@mohsin-raza , I think there is passive install method.

see if this can help

https://exceleratorbi.com.au/64-bit-power-bi-desktop-32-bit-office-can-do/

[mohsin-raza]

@amitchandak :Article looks to be good 

 with respect to "Install in Passive Mode" . should i install odbc in passive mode ?

is this work? I can not make risk on job computer