Press "Enter" to skip to content

Category: Performance Tuning

Series: Maximize SQL Performance in Power Apps

Published October 10, 2020
Series: Maximize SQL Performance in Power Apps

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…

Continue ReadingSeries: Maximize SQL Performance in Power Apps

Data VisualizationLow-CodePerformance TuningPower Apps

Azure SQL ServerCanvas AppPower AppsPower AutomatePower BISQL Server

Improve Power Apps to SQL Patch Performance

Published October 10, 2020
Improve Power Apps to SQL Patch Performance

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…

Continue ReadingImprove Power Apps to SQL Patch Performance

Low-CodePerformance TuningPower Apps

Batch PatchLow-CodePerformancePower AppsPower AutomateSQL