Hi everyone, I have the following case from a client.
In the past they have really huge excel with several pages and each page have more than 400/500 fields, in total there are more than 4000 executed columns. We have move all that Excel to a visual interface base in PowerApps, and all the calculated fields have been migrated to it by PowerFX. The app is now running correctly but it take more than 3 minutes to end the process when the excel takes just 30/40 secs. after this all the information is show in a power portal with differents graphics as a UI.
I have been thinking how to improve the calculation time of all that calculated columns, trying to put everything on a model driven and make C# Plugins, or make something in Backend, or to take DataFabrick to store everything, but I don´t really know how to improve the general performance of the process. all the suggestions are wellcome.
Thanks in anticipation.