error connecting to oracle database

Hi, jeanwilt 

 

1.Make sure you have the correct Oracle client installed on your machine. Power BI Desktop (64-bit) requires the 64-bit Oracle client to be installed. You can download the client from the Oracle website.

2.Make sure you have the correct version of the Oracle client installed. Power BI Desktop (64-bit) requires version 12.2.0.1 or later of the Oracle client.

3.Check the connection string you're using to connect to the Oracle database. Make sure it's correct and complete, including the server name, port number, database name, username, and password.

4.Make sure you have the correct driver installed for connecting to the Oracle database. In the Power BI Desktop "Get Data" window, select "Oracle" from the list of data sources and make sure you have the correct driver selected. If the driver is not listed, you may need to install it.

5.Check your firewall settings to make sure they're not blocking the connection to the Oracle database.

6.Try using a different method of connecting to the Oracle database, such as ODBC or OLE DB. You can find these options in the "Get Data" window in Power BI Desktop.

Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.