Forum Discussion

M_nwadibia's avatar
M_nwadibia
Resolver III
3 years ago
Solved

ODBC connect with Oracle Database

Please, I need help with this setback. I created ODBC connection to my Oracle Database connected to Power BI Desktop optimised for report server. Now I want to use the same ODBC to connect to my re...
8
  • v-luwang-msft's avatar
    v-luwang-msft
    3 years ago

    Hi M_nwadibia ,

    The error is caused by that you create User DSN in ODBC administrator. Please create a System DSN to points to your data source in in ODBC administrator, then add the ODBC data source under gateway. When adding a ODBC data source under gateway, make sure you enter the same connection string as that you get in Power BI Desktop. For more details, please review this similar thread: http://community.powerbi.com/t5/Integrations-with-Files-and/Personal-Gateway-X-On-Premises-Gateway/m... .

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,
    Lucien

josef78's avatar
josef78
Memorable Member
3 years ago

Check if you have installed ODBC oracle drivers correctly for both, 32bit and 64bit enviroment. You can also check connectivity from Power BI Desktop both 32bit and 64bit versions. Report Builder is only 32bit 😞

M_nwadibia's avatar
M_nwadibia
Resolver III
3 years ago

Hello,

I installed the ODBC driver for Power BI which is 64bit but if I try to create ODBC for report Builder I dont see the Oracle client 19 for selection. Does it mean you can only install the ODBC driver for oracle client just for either Power BI or Report Builder?