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.
Dear all expert,
Good day!
I'm facing the following error when I try to setup the "Manage Gateway". Kindly assist what actual issue. Thanks in advance.
Oracle: ORA-12154: TNS:could not resolve the connect identifier specified
Unable to connect: We encountered an error while trying to connect to //172.16.1.13:1521. Details: "Cannot connect to the mashup data source. See error details for more information."Hide details
Activity ID: 15369d47-6973-49f6-8006-4eaf527f7465
Request ID: 8264ced0-0fba-c892-b5e2-5606f8a87ef3
Cluster URI: https://wabi-south-east-asia-redirect.analysis.windows.net
Status code: 400
Error Code: DM_GWPipeline_Gateway_MashupDataAccessError
Time: Tue Apr 25 2017 19:24:06 GMT+0800 (Malay Peninsula Standard Time)
Version: 13.0.1700.1899
Underlying error code: -2147467259
Underlying error message: Oracle: ORA-12154: TNS:could not resolve the connect identifier specified
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Oracle
Microsoft.Data.Mashup.ValueError.DataSourcePath: //172.16.1.13:1521
Microsoft.Data.Mashup.ValueError.ErrorCode: -2147467259
Microsoft.Data.Mashup.ValueError.Message: ORA-12154: TNS:could not resolve the connect identifier specified
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error
Hi @lytan88,
In your scenario, please ensure that you install the 64-bit Oracle client, verify that the tnsnames.ora file is properly configured and you are using the proper net_service_name. You can refer to this article to configure your tnsnames.ora file with the proper information for your database.
In addition, there is a similar thread which is resolved by adding the SERVICE_NAME parameter to the tnsnames.ora file for your reference.
https://community.powerbi.com/t5/Integrations-with-Files-and/On-premise-Gateway-and-an-Oracle-Dataso...
Thanks,
Lydia Zhang
Dear all expert,
Good day!
I'm facing the following error when I try to setup the "Manage Gateway". Kindly assist what actual issue. Thanks in advance.
Oracle: ORA-12154: TNS:could not resolve the connect identifier specified
Unable to connect: We encountered an error while trying to connect to //172.16.1.13:1521. Details: "Cannot connect to the mashup data source. See error details for more information."Hide details
Activity ID: 15369d47-6973-49f6-8006-4eaf527f7465
Request ID: 8264ced0-0fba-c892-b5e2-5606f8a87ef3
Cluster URI: https://wabi-south-east-asia-redirect.analysis.windows.net
Status code: 400
Error Code: DM_GWPipeline_Gateway_MashupDataAccessError
Time: Tue Apr 25 2017 19:24:06 GMT+0800 (Malay Peninsula Standard Time)
Version: 13.0.1700.1899
Underlying error code: -2147467259
Underlying error message: Oracle: ORA-12154: TNS:could not resolve the connect identifier specified
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.ValueError.DataSourceKind: Oracle
Microsoft.Data.Mashup.ValueError.DataSourcePath: //172.16.1.13:1521
Microsoft.Data.Mashup.ValueError.ErrorCode: -2147467259
Microsoft.Data.Mashup.ValueError.Message: ORA-12154: TNS:could not resolve the connect identifier specified
Microsoft.Data.Mashup.ValueError.Reason: DataSource.Error