Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello All,
I'm trying to connect to an Oracle Data Source but it never works.
It's giving me ORA-01005: null password given; logon denied
but I was never asked for a username password. I reinstalled Power BI and I still have the same issue.
Any suggetions ?
Eric
Solved! Go to Solution.
Found the solution
#1:
Make sure you have installed:
https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64
[Released October 5, 2015]
Download ODAC121024_x64.zip - 287 MB (301,348,751 bytes)
#2:
Make sure your TNS Name file (tnsnames.ora) is correct
Test with Toad or other SQL Utility that uses the TNS NAME file
not SQL Developer (that does not use the tnsnames.ora file to Connect)
C:\app\client\your_windows_user_name\product\12.1.0\client_1\Network\Admin
#3:
In the Power BI Get Data Oracle database
In the box Server:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=service_name)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=your_service_name)))
#4:
Use the database credentials to access your data
That's it, hope it helps someone.
Eric
Found the solution
#1:
Make sure you have installed:
https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html
64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64
[Released October 5, 2015]
Download ODAC121024_x64.zip - 287 MB (301,348,751 bytes)
#2:
Make sure your TNS Name file (tnsnames.ora) is correct
Test with Toad or other SQL Utility that uses the TNS NAME file
not SQL Developer (that does not use the tnsnames.ora file to Connect)
C:\app\client\your_windows_user_name\product\12.1.0\client_1\Network\Admin
#3:
In the Power BI Get Data Oracle database
In the box Server:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=service_name)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=your_service_name)))
#4:
Use the database credentials to access your data
That's it, hope it helps someone.
Eric
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |