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/enus/powe...
Power BI Refresh Data
https://docs.microsoft.com/enus/powe...
List of Power BI data sources and their supported refresh types
https://docs.microsoft.com/enus/powe...
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 ReadOnly
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: / rezadorrani
Twitter: / rezadorrani
#PowerBI #PowerApps #PowerPlatform #WriteBack