Answered

Dynamics 365 Authentication failed

(0) Share

Report

Posted on by help10203

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

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

PranavShroti 178 on at

Like (0)

Report

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

Was this reply helpful? Yes No
help10203 36 on at

Like (0)

Report

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

Was this reply helpful? Yes No
PranavShroti 178 on at

Like (0)

Report

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

Was this reply helpful? Yes No
help10203 36 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
help10203 36 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
PranavShroti 178 on at

Like (0)

Report

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

Was this reply helpful? Yes No
help10203 36 on at

Like (0)

Report

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

Was this reply helpful? Yes No
PranavShroti 178 on at

Like (0)

Report

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

Was this reply helpful? Yes No
help10203 36 on at

Like (1)

Report

Th Thank you for your help

Was this reply helpful? Yes No
Verified answer

help10203 36 on at

Like (1)

Report
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:

'Explicit column selection' (allows PA to only select the columns from a data source it actually uses)
'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.

Was this reply helpful? Yes No