Forum Discussion

pcuezze's avatar
pcuezze
Frequent Visitor
7 years ago
Solved

32 Bit ODBC driver with 64 Bit Power BI

I am trying to connect Power BI to an Advantage Database Server via ODBC.  The Advantage Database Server is 32 Bit.  I have connected successfully in a test environment by running   1) Power BI 32 ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi pcuezze ,

     

    Both personal gateway and on-premises data gateway are 64 bit. So in this scenario, you can create a DSN within ODBC Data Sources (64 bit) under Administrative Tools, create a report use Power BI Desktop 64 bit and this ODBC data source. Then publish the report to service, enter credential for the dataset when you use personal gateway to build connection.

     

    Besides, you can also try to create a ODBC data source under on-premises data gateway, then configure the dataset use this gateway.

     

    q1.PNG

     

    q2.PNG

     

    Regards,

    Frank

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi! Did you find a solution for your 32-bit problem? I have the same error that says that the architecture does not match. Thanks in advance for a reply! 

adciudad2's avatar
adciudad2
Frequent Visitor
4 years ago

no, we did not find the solution, we are waiting to migrate the base to 64 bits directly.