Forum Discussion

harryishs's avatar
harryishs
New Member
9 years ago

Unable to login error

Hi,   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 whil...
APIS and Embedding
Report Server
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

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: https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-manage-oracle/#troubleshooting

 

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

 

Best Regards,

Qiuyun Yu