Unlocking Synergy: PowerBI and PowerApps Collaboration for Data-Driven Decision-Making

on YouTube ↗21m

" summary

Shows a concrete workflow: add a small table in mixed model with DirectQuery table to a Power BI semantic model, drag its fields into the Power Apps visual, create canvas app from Power BI Desktop so the PowerBI integration exists, add a text input per record, use Patch(...) to update the SQL table (requires a real primary key), then call Patch(...) then PowerBIIntegration.Refresh() to refresh visuals on the Service; demo updates a target from 700 to 400.

AI-written summary · about

" chapters (10)

1. 0:00PowerBI and PowerApps synergy
2. 2:19Data model for integration
3. 3:23Power App from PowerBI Desktop
4. 5:13Modify Power App for updates
5. 10:14PowerBI integration in Power Apps
6. 12:42Power Apps to SQL database
7. 13:26Update logic with Patch command
8. 15:36Live demo: filtering and updates
9. 18:40Use cases and adaptability
10. 19:01Q&A

" related talks

• 47mWrite-back with Power Apps in Power BINicky van Vroenhoven · SQLBits 2023
• 58mReal world PowerBIMatt Davies · NDC Sydney 2017
• 18mEmpowering Business Through DataDeepthi Anantharam · Great Indian Developer Summit 2015
• 01h 08mAdvanced Modelling and Calculation Using the Power BI DesignerKasper de Jonge · PASS Business Analytics Conference 2015
• 58mPower BI for the DeveloperPeter Myers, Chris Webb · NDC London 2023
• 51mPower BI Composite and Hybrid ModelsAlex Whittles · SQLBits 2023
• 48mCombine Power BI with External ToolsMiguel Félix · SQLBits 2023
• 01h 03mPower BI for the DeveloperPeter Myers · NDC Sydney 2016