Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
When i'm refreshing the dataset in staging environment. it's giving the below error message. We have oracle db connecting with TNS entry
Database - Oracle
TNS Name/Server = gmirealtime
Dataset Credentials type - Basic
username - s***_mnt_view
Password - ********
i gave the proper credentials only. issue is happening in our staging environment. for the same refreshing successful in testing enviroment data base without error.
Can you please guide me how to resolve the issue
Note: different enviroment using different logins & gateways(test_gateway, Stage_gateway)
Underlying error code: | -2147467259 |
Underlying error message: | The credentials provided for the Oracle source are invalid. (Source at gmirealtime.) |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.CredentialError.DataSourceKind: | Oracle |
Microsoft.Data.Mashup.CredentialError.DataSourcePath: | gmirealtime |
Microsoft.Data.Mashup.CredentialError.Reason: | AccessUnauthorized |
Microsoft.Data.Mashup.MashupSecurityException.DataSources: | [{"kind":"Oracle","path":"gmirealtime"}] |
Microsoft.Data.Mashup.MashupSecurityException.Reason: | AccessUnauthorized |
Cluster URI: | WABI-US-EAST2-redirect.analysis.windows.net |
Activity ID: | cb706626-d2c2-4de2-a3f4-a1922c62743b |
Request ID: | 30eb5e02-be54-84d6-91c6-a569581d4f03 |
Time: | 2020-07-21 06:24:20Z |
Previously faced error
Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the Oracle source are invalid. (Source at gmirealtime.)"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.CredentialError.DataSourcePath","detail":{"type":1,"value":"gmirealtime"}},{"code":"Microsoft.Data.Mashup.CredentialError.Reason","detail":{"type":1,"value":"AccessUnauthorized"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.DataSources","detail":{"type":1,"value":"[{\"kind\":\"Oracle\",\"path\":\"gmirealtime\"}]"}},{"code":"Microsoft.Data.Mashup.MashupSecurityException.Reason","detail":{"type":1,"value":"AccessUnauthorized"}}],"exceptionCulprit":1}}} Table: COMPANY. |
Cluster URI: | WABI-US-EAST2-redirect.analysis.windows.net |
Activity ID: | 2ab8c05c-f924-451d-a919-44f3ba726dae |
Request ID: | d77d46a4-474e-1ffe-0384-05ef3462125b |
Time: | 2020-07-06 10:34:04Z |
Solved! Go to Solution.
Hi @rveerasamy ,
Please check whether you have configured gateway correctly and select the corresponding gateway of the dataset when you configure refresh.
If you see the credentail error like below, you need to edit the credentials and re-sign-in.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rveerasamy ,
Please check whether you have configured gateway correctly and select the corresponding gateway of the dataset when you configure refresh.
If you see the credentail error like below, you need to edit the credentials and re-sign-in.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@rveerasamy - The obvious issue would be if the staging and test environments do not have the same user names and/or passwords.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.