How do I execute an R Script with a 32Bit R in PowerBI?

[Anonymous]

I Need to Access a 32bit Progress Database, and I I have the appropriate driver. I can access the database without problems using RStudio with a R32bit, for example. When trying to access this database with RStudio using a 64bit R version, I get a mistake back from the driver. Also, when trying to access thre database with a 64bit driver, it simply cannot connect.

I want to use PowerBI to access this 32bit data directly, using an RScript. When trying to do this, even when using the PowerBI 32bit version, I get the same driver mistake I get when I try to use a 64bit R through RStudio, so my assumption is that PowerBI is using a  64bit R to execute the RScripts.

If this is the case, how can I indicate that R will use a 32bit R to execute the scripts?

[v-shex-msft]

Hi @Anonymous,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak · Accepted solution]

@Anonymous , There are a few blogs are around how to deal with 32 bit, check if those can help

https://community.powerbi.com/t5/Desktop/Power-BI-does-not-support-32-bit-Access-DB/m-p/7175

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