Oracle Direct Query

[pawlowski6132]

Has anyone successfully configured this to work?

Would love to hear how you did it.

jrp

[pawlowski6132]

Thanks for your information. We have connected to Oracle and are using in production report for some time. My specific issue is connecting using the Direct Connect method of query. Can you tell me which, if any of the above pertain to Direct Connect method?

FWIW, we are using Enterprise Gateway. Is that the issue? Would this work better with PBI Report Server environment?

[v-yingjl]

Hi @pawlowski6132 ,

These considerations applied both in Import mode and Direct query mode, not have anything different.

If you are using Enterprise Gateway, the server name format is the same as the previous mentioned.

"Would this work better with PBI Report Server environment?

Have you faced some problems? If it has any error message or anything else, you can share the error message or screenshots for further discussion.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yingjl]

Hi @pawlowski6132 ,

1. To connect to an Oracle database with Power BI Desktop, the correct Oracle client software must be installed on the computer running Power BI Desktop. The Oracle client software you use depends on which version of Power BI Desktop you've installed: 32-bit or 64-bit. It also depends on your version of Oracle server.

Supported Oracle versions:

• Oracle Server 9 and later
• Oracle Data Access Client (ODAC) software 11.2 and later

Please choose a version of Oracle Data Access Client (ODAC) which is compatible with your Oracle Server.

2. During the setup of the Oracle client, make sure you enable Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level by selecting the corresponding checkbox during the setup wizard. Some versions of the Oracle client wizard selects the checkbox by default, others do not. Make sure that checkbox is selected so that Power BI can connect to your Oracle database.

3. When connecting to Oracle, provide the name of the Server, and select OK. If a SID is required, specify it by using the format: ServerName/SID, where SID is the unique name of the database. If the ServerName/SID format doesn't work, use ServerName/ServiceName, where ServiceName is the alias you use to connect.

If you are using a local database, or autonomous database connections, you may need to place the server name in quotation marks to avoid connection errors.

4. After you've entered your Oracle database information in the Oracle database dialog (including any optional information such as a SID or a native database query), select OK to connect.

5. If the Oracle database requires database user credentials, input those credentials in the dialog when prompted.

If connect to oracle with errors, please check your tnsnames.ora file is properly configured and you're using the proper net_service_name

For more troubleshottings about oracle, please refer: Troubleshooting - oracle  

You can also refer these similar issues:

1. Oracle Direct Query - Couldn't Connect 
2. Oracle.DataAccess.Client - direct query error 
3. Workarounds for using Direct Query with Oracle 11g

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.