Unable to connect to Oracle database

[Anjali_s_k]

Hi Folks,

I am facing the problem in getting connected to Oracle Database, I am able to get the data but failing to create a model out of it. the error pop up goes something like this

Any help will be appreaciated!

Regards,

Anjali

[Kishore_KVN]

Hello @Anjali_s_k , 

Please see if Oracle Client 12 is installed in your system or not. Once it is installed, Place the entire folder with TSN files in the C drive. Then it will connect. If it doesnt connect then install Oracle ODBC 64/36 drivers as per your system configuration. This will helps to connect. 

If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

[Anjali_s_k]

Hi @Kishore_KVN 

I have installed Oracle client already along with TNSORA file in C drive, still aint working.

[Kishore_KVN]

Then install Oracle ODBC drivers and while providing the server in Power BI under connecting to Oracle, then you have to use servername\PortName