Explore how to seamlessly embed Power BI and Power Apps into one another to create powerful, integrated tools for real-time data insights and actions. Hosted by Cristian Prifti and Bogdan Donose, this session dives into practical demonstrations, focusing on building apps that interact with Power BI for a dynamic user experience.
Timestamps:
00:00 Introduction
00:36 Meet the Team: Bogdan and Cristian
01:54 Overview of Today’s Session
03:33 Captain America in Power Apps - Field Agent Demonstration
07:18 Writebacks to the Fabric Warehouse using Power Automate
15:05 Embedding Power BI into Power Apps
24:18 Handling Large Data Sets in Power Apps
34:38 Dispatcher Role - Power BI Embedded in Power Apps
50:45 Q&A and Final Remarks
In this insightful session, Cristian Prifti and Bogdan Donose demonstrate the power of embedding Power BI and Power Apps into one another, showcasing how this integration can revolutionize data handling and user interaction.
The video begins with a light-hearted introduction, comparing the presenters to famous dynamic duos like Batman and Robin, setting the tone for a collaborative and informative session. The discussion then shifts to a detailed walkthrough, starting with a demonstration of Power Apps designed for field agents, where Captain America serves as a fun persona for showcasing real-world application use.
One of the key focuses of the session is the process of "writebacks"-using Power Automate to update data in real-time back into a Fabric Warehouse. The presenters break down the technical details behind using Power Automate within Power Apps and explain why direct data patches are not always feasible, showcasing SQL queries and custom automations as solutions.
Further, the presenters explore embedding Power BI tiles within Power Apps, explaining how users can interact with data and even customize the filtering using SQL views. They provide tips on handling large data sets and overcoming challenges with non-delegable functions.
The session concludes with a detailed look at the dispatcher role, embedding Power Apps within Power BI for efficient task management, and a Q&A where important considerations such as licensing and best practices for managing writebacks are discussed.
If you’re interested in advanced Power Platform integrations, this video is packed with practical knowledge, hands-on demonstrations, and expert insights.
Resources collated by Takami Ryuto-Smith:
Power Platform Tutorials by Tolu Victor on TH-cam
www.youtube.com/@toluvictor
VSCode extension for power fx #227 on GitHub
github.com/microsoft/Power-Fx/discussions/227
Query limitations: Delegation and query limits on Microsoft Learn
learn.microsoft.com/en-us/power-apps/maker/canvas-apps/delegation-overview
Recover Power BI reports or models that you can’t download - Data Goblins
data-goblins.com/power-bi/cant-download-pbix
ByteWise - Cristian Prifti & Bogdan Donose
www.bytewise.digital/