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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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