ODBC connect with Oracle Database

[M_nwadibia]

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 report builder I get this error. When I tried to create ODBC with 32bit I get another error. Kindly advise on what I should do in this situation

[josef78]

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]

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?

[M_nwadibia]

Hello,

I use both Power BI Desktop and Report Builder to create my reports. The ODBC works in Power BI destop but when I try to use it in Report Builder I get the error below.

I need help on the steps to resolve the error.

[v-luwang-msft · Accepted solution]

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

[M_nwadibia]

Hello, 

I tried creating the ODBC in system DSN and I get this error

[M_nwadibia]

Hello,

I am using a Report server and not Power BI service. I dont need a gateway in this case.