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.
