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
5,398 views

2 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,440 points
+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

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,440 points
4,364 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,440 points
179 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
• 51,830 points
468 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,440 points
976 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
• 57,530 points
125 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
2,835 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
73 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,440 points
1,724 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,440 points
1,975 views