Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jeanwilt
Regular Visitor

error connecting to oracle database

unnamed.png

2 REPLIES 2
v-zhangti
Community Support
Community Support

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.

Good afternoon, the installed version of Oracle 12 64 bits.

In power bi desktop, I can connect the data source, but in power bi online this message appears.

I'm Brazilian, I'm writing through the translator.

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors