Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.