How to connect to oracle database from power Bi?

BI Tools

How to connect to oracle database from power Bi?

1
Answers

Replies

Ans: Below are the steps to be followed to connect to Oracle database from Power BI.


You will need to click on the Get data option.
Navigate to the database and select the Oracle database option.
You can click on the link here at https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database#installing-the-oracle-client if it is oracle provider.
Download and complete the installation process.
Type in the server name.
Update or type in the SQL statements which is optional, can be done based on your choice.
You will need to now connect the data through import or direct query  to the Oracle database.
Select the mode of authentication whether it is window or database or Microsoft account.
Now you need to select the required tables and fields present in the oracle database for creation of the visualizations and reports.
Click on OK.
The data is now retrieved and ready for creation of visualizations.

 
 

If you want to unleash your potential in this competitive field, please visit the BI Tools course page for more information, where you can find the BI Tools tutorials and BI Tools frequently asked interview questions and answers as well.

 

This topic has been locked/unapproved. No replies allowed

Login to participate in this discussion.

Leave a reply

Before proceeding, please check your email for a verification link. If you did not receive the email, click here to request another.