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
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!