Forum Discussion

Anup1004's avatar
Anup1004
Advocate I
4 years ago

Refresh 32 bit Oracle database

Hi All,

 

I have a 32 bit Oracle database for which i installed 32 bit Power BI desktop and have prepared a report. Now when i try to refresh this report from Power BI service, then it does not allow me to as the gateway is 64 bit and database is 32 bit.

 

I know this is a limitation, however is there any solutin to this as i can't ask my client to suddenly change their structure from 32 bit to 64 bit.

 

Request for help here

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Anup1004 , is the gateway and power bi desktop on the same server? 

     

    Install the 64-bit oracle driver on the gateway server and test creating the connection again.

    • Anup1004's avatar
      Anup1004
      Advocate I

      How to check the server for gateway? Also, i might not be able to install anything on the oracle side given that the client is already on the 32 bit.

       

      Everything works fine for me on the Power BI desktop, as i had installed a 32 bit however i am facing issues at the Power BI service end where the gateway and oracle are of different versions.

       

      Really need a solution for this or else there would be absolutely no use of the efforts made in creating the reports. Not sure on how to proceed

  • Can someone please help here. Any other solution as well if anyone is aware of in this scenario