Forum Discussion
Helper IVConnect To Oracle Database
I need a connection solution for Oracle. This shouldn't be this difficult. I am trying to connec to an Oracle server and get the following:
However, the Oracle client is installed. I try to connect:
When I connect I get the following error:
Figured it out. After finding the path for the .ora file I entered the information in the file. Then in PowerBI I added the connection name from the .ora file to the connection string
27 Replies
- Greg_Deckler
Community Champion
I'm not an Oracle guy but my impression from being around it is that the words "Oracle" and "not difficult" do not belong in the same sentence. :)
Perhaps this will help? http://www.dbasupport.com/forums/showthread.php?61511-ORA-12504-TNS-listener-was-not-given-the-SERVICE_NAME-in-CONNECT_DATA
One other thing, do the bits match between Power BI Desktop and Oracle Client?
- jmiridium
Did all the steps get a different failure:
- jmiridium
Figured it out. After finding the path for the .ora file I entered the information in the file. Then in PowerBI I added the connection name from the .ora file to the connection string
- sqldusty
Microsoft Employee
This made me laugh.
dniedrauerResolver I
It ended up being a firewall issue. Everything was done correctly.
Get data/ oracle database, then use this string to server: (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=XE)))
see https://blogs.solidq.com/en/businessanalytics/get-data-in-power-bi-from-oracle-database/. succeed to connect to oracle now.
Thanks alot, this worked for me, if you dont use a service_name but just a SID you can change the last part
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SID=XE)))
Hello,
I am new to learning Power BI. I need to connect Oracle Cloud Database to Power Bi.Can anyone pls guide me steps as how should i bring data to power bi and create reports. I have only found that this can be done using API's. Hence, i connected power Bi with Powershell and using those cmdlets i have login into power bi. Am i on the right path?What should i do further to connect with Oracle Cloud database
