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.
Solved! Go to Solution.
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:
These 2 options really helped me. They also mentioned that you should use the entities more often so it would trigger dynamics auto tuning.
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
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.
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.
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.
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.
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 ?
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.
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.