Loading
Channel: @RezaDorrani
In this video, I will show how to write back data to the data source from Power BI by using the Power Apps Visual. Video tutorial shows how to add, update & delete data in data source directly from Power BI report by using the Power Apps Visual. The Power App will connect to the data source and perform the Write Back (CRUD) Operations. We will leverage SharePoint as Data Source and perform the writeback. I will also demonstrate how to leverage Dataverse for Write Back. Dataverse & SQL Support DirectQuery Import mode. This allows the Power App to initiate a near real time refresh of the Power BI Visuals from Power Apps by use the PowerBIIntegration.Refresh() function. The Power App will get its data from the Power BI dataset.
Power BI DirectQuery mode Vs Import mode https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data
Power BI Refresh Data https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#data-refresh
List of Power BI data sources and their supported refresh types https://docs.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources
Table of Contents: 00:00 - Introduction to Power BI write back with Power Apps 00:46 - Can't input data from Powe BI as PBI datasets are Read-Only 02:19 - Power BI data Write Back with Power Apps 03:48 - Create Power App connected to Power BI 07:47 - Perform Update operation in Data Source from Power BI using Power Apps 16:38 - Add & Delete records in Data Source from Power BI using Power Apps 19:35 - Power BI WriteBack Data with Live Refresh (DirectQuery) 22:24 - Power BI Write Back Bulk Data with Live Refresh (DirectQuery) 23:58 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social: 🔗 LinkedIn: https://www.linkedin.com/in/rezadorrani/ 🐦 Twitter: https://twitter.com/rezadorrani
#PowerBI #PowerApps #PowerPlatform #WriteBack