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.
Hi,
I want to connect two different server of oracle database for reports in Power BI Desktop using ODAC (Oracle Data Access Components). How to do it (if it is possible) ?
Solved! Go to Solution.
After a bit digging up I found the solution to add different oracle server in PBI.
To connect with oracle server we have to install oracle client i.e ODAC in which we have tnsnames file which basically stores the information about network service names in which using following systax we can add multiple servers oracle servers to PBI
service_name =
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = example1.com) )
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = example2.com) )
)
)
After a bit digging up I found the solution to add different oracle server in PBI.
To connect with oracle server we have to install oracle client i.e ODAC in which we have tnsnames file which basically stores the information about network service names in which using following systax we can add multiple servers oracle servers to PBI
service_name =
(DESCRIPTION_LIST=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = example1.com) )
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = example2.com) )
)
)
@neetikulkarni , In import mode you can get data from more than one connection. As long as you are able to connect.
@amitchandak thank you for reply, but I want to connect two different server of oracle, using the method you mentioned I'm getting error as: Details: "Oracle: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"
Hi @neetikulkarni ,
Refer:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |