Forum Discussion

M_nwadibia's avatar
M_nwadibia
Resolver III
4 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

v-luwang-msft's avatar
v-luwang-msft
Community Support
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

M_nwadibia's avatar
M_nwadibia
Resolver III
3 years ago

Hello,

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