Dynamics Nav on-premises Odata authentication problem

[Anonymous]

Hi Team,

I tried to connect my MS Dynamics Nav On-premisis data to power BI using On-premisis data gateway (OData) but am getting authendication issue in Service. Below are the error details

(Shedule Refresh) but working correctly with desktop

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details
Activity ID: b2eca0cd-481a-47de-a2c4-8fcfc4fbe422
Request ID: 6f9c2c3c-64e1-1306-7ad7-da1cb60e1094
Cluster URI: https://wabi-us-east-a-primary-redirect.analysis.windows.net
Status code: 400
Error Code: DMTS_PublishDatasourceToClusterErrorCode
Time: Thu Jul 25 2019 08:22:17 GMT-0400 (Eastern Daylight Time)
Version: 13.0.10175.153
Nav-PowerBI integration: Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The credentials provided for the OData source are invalid. (Source at http://XXXXXX:8048/LATESTDATA/OData/Company('XXXXXX%20Inc-TEST')/Time_sheet_header.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: OData
Microsoft.Data.Mashup.CredentialError.DataSourcePath: http://XXXXXX:8048/LATESTDATA/OData/Company('Melillo%20Consulting%20Inc-TEST')/Time_sheet_header
Microsoft.Data.Mashup.CredentialError.Reason: AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"OData","path":"http://XXXXXX:8048/LATESTDATA/OData/Company(\u0027XXXXXX%20Inc-TEST\u0027)/Time_sheet_header"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: AccessUnauthorized

My Gateway connected  please find below image. and i provided proper credentials 

Please help me to resolve the issue.

Regards

Supreeth J

[v-xicai]

Hi @Anonymous ,

From the error message "The credentials provided for the OData source are invalid", please check if the entered Microsoft Dynamics NAV OData URL is correct. The URL should match the following pattern:

https://instance.navserver.com:7048/DynamicsNAV90_Instance1/OData/Company('CRONUS%20International%20...

"instance.navserver.com" with your NAV Server name

"DynamicsNAV90_Instance1" with your NAV Server Instance name

"Company('CRONUS%20International%20Ltd.')" with your NAV Company name
An easy way to obtain this URL is in Dynamics NAV to go to Web Services, find the powerbifinance web service and copy the OData URL, but leaving out the “/powerbifinance” from the URL string.

You can learn more about Connect to Microsoft Dynamics NAV with Power BI .

Or try to upgrade the gateway to the latest version.

You may resolve the issue via the troubleshooting link :https://docs.microsoft.com/en-us/power-bi/refresh-troubleshooting-refresh-scenarios .

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hi @v-xicai 

Nav instance and company is correct am able to fetch data in power-bi desktop and browser , getting above error while connecting on-prem gateway to power-bi service 

Regards

Supreeth