Showing results for 
Search instead for 
Did you mean: 
harryishs Frequent Visitor
Frequent Visitor

Unable to login error



Until last week i was able to connect with PowerBI desktop,but today when i try to login and connect my oracle database,randomly i am getting error like this:


We encountered an error while trying to connect:

Details: "Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA


I am unsure what is the reason behind this and i am trying to figure out in vain,Could someone please fix the issue or please let me know how to get this working,i tried several ways but unable to get it cleared.



Moderator v-qiuyu-msft

Re: Unable to login error

Hi @harryishs,


Regarding the error message "Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA", the issue should be caused by Oracle client is not installed, or if it is not configured properly. If it is installed, you will want to verify the tnsnames.ora file is properly configured and you are using the proper net_service_name. See:


You can also take a look at jmiridium 's suggestion in this similar thread Connect To Oracle Database .


Best Regards,

Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 116 members 1,514 guests
Please welcome our newest community members: