cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NiSo
Regular Visitor

NAV odata - organizational account

I'm trying to connect to my NAV 2017 deployment that is configured to authenticate with O365 but the Power BI desktop application is throwing the error message "The token service reported by the resource is not trusted"

 

I'm using Organizational account for the Odata feed.

Any help is appreciated.

4 REPLIES 4
v-ljerr-msft
Microsoft
Microsoft

Hi @NiSo,

 

To troubleshoot this issue, could you try connecting to Microsoft Dynamics NAV content pack on Power BI service with the same account by following steps from this article to see if the issue remains?Smiley Happy

 

Regards

Hi,

 

thanks for your reply.

Connecting to NAV using the content pack works fine.

But the difference is that using the NAV content pack, you can only connect with Basic authentication.

Where the Desktop APP supports the Organizational Account.

 

When I connect to the Odata using an organizational account, I do see outgoing traffic on the NAV server to (my assumption would be O365 login page?) and then the error is thrown in the BI client. Logging in with the MS Dynamics NAV client works fine using O365/organizational account credentials.

 

I have tried 2 different approaches, using the common Azure AD authentication page in the NAV setup and using the dedicated Azure AD. Both work fine for the NAV client, but Power BI returns the same error when clicking on the "sign in" button.

 

NiSo.

NiSo
Regular Visitor

Once I changed the value TokenAuthorityEndpoint on the NAV server to the endpoint for my Azure AD, I now get prompted with the credential box for WAAD. But after authentication it is not able to find the "registered application" with the URL name of my NAV server. Not sure wherepower BI specifies this app name? 

 

In meantime I have reported a call at MS premier support.

Hi,

 

Did you manage to solve this. I have the same issue on Dyn365-Business Central (NAV2018 I guess). But it's a Saas solution, so I can't really change much

 

Thanks,

Johan

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors