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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ayanDuisenov6
New Member

Power BI Desktop and Oracle database connection

Hello everyone!

I am trying to connect to an Oracle database that is located on a server. To connect to this database, I need to run a .bat file (the script of this file looks like "start PUTTY.EXE -ssh -L host:ip:host ip_Of_the_server -l test -i test.ppk") and then enter the database credentials. I can connect to this database from various IDEs, such as DataGrip and SQL Developer.

The problem is that all tutorials on "Connecting Power BI to Oracle" explain how to connect to local databases, but in my case, the database is hosted on Google Cloud (if I am not mistaken).

It would be greatly appreciated if someone could share their own experience and knowledge with me!

1 REPLY 1
ayanDuisenov6
New Member

I made a mistake here "start PUTTY.EXE -ssh -L host:ip:host ip_Of_the_server -l test -i test.ppk"
Instead of the host, it should be port, so "start PUTTY.EXE -ssh -L port:ip:port ip_Of_the_server -l test -i test.ppk"

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.