How to connect to oracle database from power Bi

+1 vote
How to connect to oracle database from power Bi?
Mar 22, 2019 in Power BI by sindhu
14,948 views

3 answers to this question.

+1 vote

Hi,

1. Click on Get Data.
2. Go to Database and select Oracle database.
3. For oracle provider, click here https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database#installing-the-oracle-client
4. Download and install the same.
5. Then Type your server name.
6. Type any sql statements. (optional)
7. Connect data through import or direct query to Oracle database.
8. Select mode of authentication (window /database/Microsoft account)
9. Select required tables and fields residing in oracle database for creating your report and visualization.
10. Click Ok.
11. Now the data is retrieved and is ready to create visualizations.

Hope this helps you.

answered Mar 22, 2019 by Cherukuri
• 32,990 points
Hi,

I have followed the exact steps as you mentioned and connected a PBI with one server.

But now I want to add more than one server, how can I do that?

Thanks,
Hi, @Neeti,

Yes, you can connect to multiple data sources from the Report Server.
Report Server has a folder structure - permissions are managed at the portal, folder, or individual report level and can be assigned to individuals or AD groups.

The Power BI mobile app will also connect to the Report Server for on the go access.
You may need a VPN client on your device to access - depends on your setup and security requirements.
+1 vote

I use Devart ODBC drivers in order to create a connection with Power BI https://www.devart.com/odbc/powerbi/

How to connect Power BI to ODBC data source and access data in 3 steps:

  • Install the driver and configure an ODBC data source. Start Power BI and choose Get Data > Other > ODBC.
  • Choose the DSN that you configured for the ODBC Driver and enter your credentials in the next step.
  • Now Power BI database connection is established: you can load a table for business intelligence reporting.

answered Dec 20, 2019 by Tony
• 160 points
0 votes

HII.

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 the Oracle server.

Supported Oracle versions:

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

    Determining which version of Power BI Desktop is installed

    To determine which version of Power BI Desktop is installed, select File > Help > About, then check the Version line. In the following image, a 64-bit version of Power BI Desktop is installed:

    Power BI Desktop version

    Install the Oracle client

  • For the 32-bit version of Power BI Desktop, download and install the 32-bit Oracle client.

  • For the 64-bit version of Power BI Desktop, download and install the 64-bit Oracle client.

    Determining which version of Power BI Desktop is installed

    To determine which version of Power BI Desktop is installed, select File > Help > About, then check the Version line. In the following image, a 64-bit version of Power BI Desktop is installed:

    Power BI Desktop version

    Install the Oracle client

  • For the 32-bit version of Power BI Desktop, download and install the 32-bit Oracle client.

  • For the 64-bit version of Power BI Desktop, download and install the 64-bit Oracle client.

    Connect to an Oracle database

    After you install the matching Oracle client driver, you can connect to an Oracle database. To make the connection, take the following steps:

  • From the Home tab, select Get Data.

  • From the Get Data window that appears, select More (if necessary), select Database > Oracle database, and then select Connect.

    Oracle database connect

  • In the Oracle database dialog that appears, 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.

    Enter Oracle server name

     Note

    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.

  • If you want to import data by using a native database query, put your query in the SQL statement box, which appears when you expand the Advanced options section of the Oracle database dialog.

    Expand Advanced options

  • 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.

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

  • You might encounter any of several errors from Oracle when the naming syntax is either incorrect or not configured properly:

  • ORA-12154: TNS: could not resolve the connect identifier specified.
  • ORA-12514: TNS: listener does not currently know of service requested in connect descriptor.
  • ORA-12541: TNS: no listener.
  • ORA-12170: TNS: Connect timeout occurred.
  • ORA-12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA.
  • These errors might occur if the Oracle client either isn't installed or isn't configured properly. If it's installed, verify that the tnsnames.ora file is properly configured and you're using the proper net_service_name. You also need to make sure that the net_service_name is the same between the machine that uses Power BI Desktop and the machine that runs the gateway. For more information, see Install the Oracle client.

    You might also encounter a compatibility issue between the Oracle server version and the Oracle Data Access Client version. Typically, you want these versions to match, as some combinations are incompatible. For instance, ODAC 12.x does not support Oracle Server version 9.

  • If you downloaded Power BI Desktop from the Microsoft Store, you might be unable to connect to Oracle databases because of an Oracle driver issue. If you encounter this issue, the error message returned is: Object reference not set. To address the issue, do one of these steps

  • Download Power BI Desktop from the Download Center instead of Microsoft Store.

  • If you want to use the version from Microsoft Store: on your local computer, copy oraons.dll from 12.X.X\client_X to 12.X.X\client_X\bin, where X represents version and directory numbers.

    Regards,
    SRI

answered Oct 28, 2020 by SRI

Related Questions In Power BI

+2 votes
1 answer

How to connect to mysql database from power Bi?

Hi, Follow these steps, to connect to MYSQL ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,990 points
17,068 views
0 votes
1 answer

How to connect to sql server from power Bi?

Hi, Follow these steps to connect to SQL ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,990 points
507 views
0 votes
1 answer

How to publish .pbix report from power bi desktop to power bi service directly?

To save powerbi file directly to report ...READ MORE

answered Sep 27, 2018 in Power BI by Kalgi
• 52,370 points
1,092 views
+2 votes
1 answer

How to export data to CSV from power bi embedded url ?

Hi Arathi, You can open Visuals from embedded ...READ MORE

answered Aug 23, 2019 in Power BI by anonymous
• 32,990 points
3,718 views
0 votes
1 answer

How can i copy tables from one database to other on AWS?

You can use AWS Data pipeline to ...READ MORE

answered Jul 5, 2018 in AWS by Priyaj
• 58,120 points
831 views
0 votes
1 answer

How to increase Swap Memory in CentOS 7?

Follow the below steps and procedures: Prerequisites Must have ...READ MORE

answered Oct 5, 2018 in Linux Administration by Frankie
• 9,810 points
7,462 views
0 votes
1 answer
0 votes
1 answer

How do I enable Oracle automatically on systemboot?

To enable the database service to start ...READ MORE

answered Oct 5, 2018 in Database by Frankie
• 9,810 points
146 views
0 votes
1 answer

How to connect to sap Hana database from power Bi?

Hi, Follow these steps to connect to data ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,990 points
4,271 views
0 votes
1 answer

How to connect to IBM DB2 database from power Bi?

Hi, Hi, Follow these steps, to connect to IBM ...READ MORE

answered Mar 22, 2019 in Power BI by Cherukuri
• 32,990 points
7,331 views