cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
help10203
Frequent Visitor

Dynamics 365 Authentication failed

Good day

 

My app has been running for months but today all users are receiving the following error: "One or more of your connections may not be authenticated. Tap here to fix" - tapping does not do anything.

 

I am not finding anything online

 

All my connections have a status of 'Connected'. I think it is D365 connection that is the problem because if I remove any code related to one if its entities everything is working fine. I can access the connections and Entities in Power Apps but in the app it throws this error.

 

It is also worth noting that the data does eventually come through it is just exceptionally slow.

 

Please advise

1 ACCEPTED SOLUTION

Accepted Solutions

Hello. I logged a support request with Microsoft and their suggested solutions were rather helpful.

 

In your Power App, if you go to 'Settings' > 'Advanced Settings', there are 2 options you should select:

 

  1. 'Explicit column selection' (allows PA to only select the columns from a data source it actually uses)
  2. 'Improve data source performance & CDS views'

These 2 options really helped me. They also mentioned that you should use the entities more often so it would trigger dynamics auto tuning.

View solution in original post

10 REPLIES 10
Pranav_Shroti
Kudo Collector
Kudo Collector

Few things you can quickly check - 

1. Open D365 environment and check if that is performing as per expectations 

2. Try to point to a lesser environment other than production and see if behavior is same 

3. Try to create a copy of existing app and check how it behaves 

 

Regards,

Pranav

Hello!

 

1) It is performing normally

2) I pointed to the Sandbox environment with the same entities and the performance was also normal, performing at usual speeds with no errors

3) I made a copy and it still had the same problem.

 

Kind Regards

Will it be possible to share some more info like what info you are trying to pull/push from D365. Any specific entity or operation you are struggling with.

 

Regards,

Pranav

Of Of course!

 

I am having trouble with all the entities I am referencing. However, the main ones would be Cases, Opportunities, Users. I also have two custom ones I created - they look very similar to Appointments.

 

It seems like pulling the data is the main problem - but as I said before it takes really long and throws the error before eventually displaying the data - it does sometimes display the incorrect info as well). I utilize Microsoft Flows to insert into the entities which do work - but also take really (really, really) long.

 

One user also got a 'Server timeout execution' error before getting this main error.

My apologies. I made another app with the same connections (Cases & One Custom entity) and placed the data in a gallery as a test. Cases loaded immediately, however, the custom table received a Server timeout - so I think the custom entitities are the issue.

 

Any advise?

How many records are you trying to pull for current user ? Can you filter the records returned, apply vertical and horizontal filters. That might help. Like instead of querying all columns, just query what is required or apply paging, query records on demand.

 

Regards,

Pranav 

Typically returning less than 10 records for each user. In total there is about 200 records in the entity.

And in my Sandbox environment it has about the same but does not encounter the same issues.

 

I will try those techniques you mentioned but I don't think it should be having trouble with an entity with so little records ?

 

Kind Regards

I suspect this could be an environment specific issue, as all other parameters are same. I guess you might want to raise a ticket with MS as well.

 

Regards,

Pranav

Th Thank you for your help

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,678)