Lessons learned in canvas apps performance while integrating Azure SQL, Power Apps and Power BI In my last two projects, I was asked to create a Power BI dashboard with write-back functionality. This is a common request from users, an innocent question of “oh, let me change that number (in Power BI)” or “let me add row there”. Rise in…
Power Apps can deal with basic anthemics. But unless your requirement is to build a four function calculator, you will need to incorporate few other pieces from Microsoft’s arsenal. In the following solution, I will calculate linear regression in Power Apps with user defined axis. This will be achieved with the following combination: Power Apps: Handle user inputs and shows…
For my use case, I had to: 1. Load a SQL table/view to a collection 2. Record user updates in collection 3. Insert updated records to SQL The challenge I faced was the slow performance of ForAll and Patch commands when used with SQL. This is the standard method outlined in Power Apps reference documentation, but I couldn’t get it…
