I have a Power App writing back to Excel and is hosted on a Power BI Report, but the Power App is taking way too long to load for anyone to enter comments. Is there a way I can fix this and enhance the load time? The App is really simple and has 5 input fields defined for users to use and add their personalized comments in.
So my Power App basically writes back to an Excel Online file hosted on OneDrive, I then use the PowerApps custom visual and call the Power App from there. This PowerApps has the PowerBIIntegration in it as well, which filters data for both the data on Power BI front and the data on the Power Apps as well. While this report is loading on the Power BI service everything loads quick except the Power Apps, which takes 30-40 seconds and at times users have to refresh the page to make it load.