Unanswered

PowerApps Portal - Performance Issue

(0) Share

Report

Posted on by Svintsitsky

Hello,

We created PowerApp portal on our tenant and it performs extremely slow. It is a Production portal and has Login capacity add-on license to allow External Authenticated users to access it.

PowerApps Portal is used as a shell where user can sign in and then is presented with different PowerBI reports embedded using PowerBI Embedded Service.

It take likes ~40 seconds to login and ~30seconds after clicking on the different reports in the menu. Obvious bottle neck might be the PowerBI Embedded instance as it is processing reports and it might take a long time BUT actually it take like 25 seconds just for PowerApps portal to process requests and only then PowerBI kicks in and presents report under 3-4 seconds.

We have a ticket opened with Microsoft for over a month and being told that our case is being escalated and Engineering team is working on it without any details or ETAs. Also they mentioned that this is a back end issue and there is nothing we can do to help.

At this point our Management Team is discussing/deciding should we drop the PowerApp portal and start developing custom portal instead of using Microsoft PowerApps one...

Did anyone else experience performance issues with the PowerApps portal?

Any ideas/advises on what could we try/do?

Thank you.

Categories:

Power Apps portals

I have the same question (0)

All responses (8)

Answers (0)

ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Svintsitsky,

We are using exactly the same scenario with PowerBI embedded along with Role Level Security. I have done the performance test just to ensure how long it is taking before I write my reply. I ran 3 times and the results are 12-17 secs maximum to load the PowerBI embedded .

NB: Reports layout and rendering differs every time depends on who is logging in . Because Row Level security has been applied.

1. To Increase Login performance time: You can configure Azure AD or Azure AD B2C or any oAuth/ OpenId to make it simplified. Once this is configured then browser will remember the authentication token and allow the users to sign in with single sign on.

2. To increase Power BI report loading time: You can perform all your calculation in ETL / data warehouse area instead of performing it in Power BI. Dataverse direct query is recently introduced link here .

Perhaps at this stage it may be slow, we can notify Microsoft to look in to this. In our reports are loaded in to SQL Data warehouse in Azure / Azure SQL database.

Hope this give you some time to think on what is happening to other users.

PS: Overall the performance is really improved and every wave release is there are significant changes Microsoft is deploying.

Hope it helps.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Svintsitsky 3 on at

Like (0)

Report
Copy link

Link copied!

Hello @ragavanrajan,
Thanks a lot for your detailed reply.

1) We are using Azure AD B2C. Even when I am using my account(created on the tenant, not invited) I can enter username and password pretty quickly but after authentication, when I am presented with a "Stay signed in?" window and clicking Yes or No it takes ~20-30seconds to present home page of the PowerApps portal after authentication. Is this expected behavior? What are you seeing in terms of the sign in performance?

2) Thanks for pointing it out. Our reports do not have a lot of complex calculations/computations performed on the PowerBI level (at least yet), main goal is to present/visualize normalized data from Azure Table storages and CDS.

Are you using PowerApps portal in production? Based on your experience is a production ready? Meaning is it suitable for extensive usage by external users?

Thank you.

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hi @Svintsitsky ,

1) For option 1 I have rechecked the stay signed in option. For us it is taking hardly ~10 to 16 seconds max. Analyzed using Fiddler as well. No traffic is passing while signing in. you may need to try Fiddler to see what's happening. Perhaps could you please check is there any firewall or proxy issues which is loading in your organization that is causing the slowness. I have done the test with many of my colleagues and the result is the same.

2) As I mentioned already any calculation if you do it in ETL / Data warehouse area it would be better. You have only one option here which is to use the Dataverse direct query which you will experience certain delays. To implement lazy loading of the powerBI reports the only way is to use AZURE ETL.

Caveat: There are some known issues as well as in my solution assigning automatic web roles via power automate will take at least 5 to 10 minutes to reflect the role or some one has to press the sync configuration button manually.

There are some upside and downside, we have considered custom development and then powerapps portal. In many ways PowerApps Portal integration is much better than writing code for single page application development. It purely saves time and cost. We went live for external users and they are happy with the portal so far.

Personally the product will mature in coming season as Microsoft is considering our request and improving it significantly.

Hope it helps.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
vjakimov 9 on at

Like (0)

Report
Copy link

Link copied!
Hi @ragavanrajan ,

Out of those 12-17 secs for loading the PowerBI embedded, how much time does it take to:
load the initial DOM
load the PBI iframe DOM
load the report inside the iframe
Thanks

Was this reply helpful? Yes No
justinburch Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @Svintsitsky,
This was going to be my question to you, re: whether it was a Production instance. I've had the very issue you're describing with trial environments commonly, and occasionally with environments that weren't used as much. My assumption is probably based on the back-end setup of your portal: hosting location, app plan, maybe a competing resource, etc. It could be that the app is utilizing a cold start and the lack of use is why it's taking awhile. I'd trust the support team to figure it out!

One thing you could do to understand if the issue is Power BI or not is to test whether or not this occurs when you remove the Power BI embedding (if done via liquid in template, just wrap the report in {% comment %} {% endcomment %} tags. If it's easier to keep the Power BI, try to set another page/URL to require authentication and navigate there directly or, alternatively, construct your own - e.g. https://svintsitskysportal.powerappsportal.com/signin/?returnUrl=%2Fcustom-page%2F - to sign in and go to a page that doesn't contain a report.

Please note that while I have the employee tag, I don't work with the product group in any capacity, and this assumption is based solely on previous implementations. 🙂

Was this reply helpful? Yes No
vjakimov 9 on at

Like (1)

Report
Copy link

Link copied!
I am sharing this to help the community in case others are having similar issues.

One of the bigger problems we had in our case was the following:
We have added custom left menu in the header
The business logic for generating this menu was complex
We have used liquid tags which were joining multiple tables to get the needed data for the menu links
Looks like power apps is caching the header separately for each user since they can't know your business logic and they have to assume that the header might be different for each user
Because of the above, after each sign in, looks like power apps is recreating the cache of the header
Looks like until that cache is recreated, a redirect to your portal is not happening so you will never think that the problem is in your code since it looks like the sign in is still in progress
Also we were getting slow page loads now and then even when the power apps cache was still valid
So it looks like the header is sometimes being recreated even though the power apps cache is still valid
There are a lot of "looks like" above since we don't know how power apps works in the background and we can only assume based on what we have experienced.

Was this reply helpful? Yes No
ragavanrajan 7,044 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Thank you @vjakimov for sharing it. Really useful.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Svintsitsky
We are also using powerapps portal but not power but not PBI reports in it and facing slowness issue. We are in the same boat.
Did you find any solution?

Was this reply helpful? Yes No