The CRE ODBC has to be 32-bit because CRE is also 32-bit.  But you can use a 64-bit connection to your server, as long as you create a separate DSN.

The CRE ODBC has to be 32-bit because CRE is also 32-bit.  But you can use a 64-bit connection to your server, as long as you create a separate DSN.

Hi Jay,

Is there anyway you can further explain this? We are attempting to start testing out PowerBI using our Sage300 data and currently connect to PowerBI using an ODBC connection. Our issue is that since the Sage300 driver is 32 bit and the PowerBI 'Data Gateway' app we use is 64 bit (no 32bit option) they are incompatible and therefore automatic refreshes aren't possible which is discouraging us from building reports and moving forward. We would like end users to be able to refresh data themselves without having someone with the backend knowledge going into individual reports and refreshing source files etc...

The SQL replicator is looking like an option as well...

Thank you,

Jon