Day 16 - Use PowerApps to insert/update/delete and search data in Power BI

Prerequisite:

You should have knowledge of Power Apps to build INSERT/UPDATE/DELETE custom form and data source should be SharePoint Online List or SQL Server.

So you should be ready with a PowerApps custom form which would have ability to insert/update/delete data directly from the data source

Ask:

Is it possible to INSERT/UPDATE/DELETE data directly in POWER BI ?

Yes, it’s quite possible to achieve the functionality using PowerApps in POWER BI. I have tested it on Data Source - 'SharePoint List' and it’s working as expected  🎉🎉

Please follow step-by-step instructions below.

1.       Launch POWER BI Desktop tool

2.      Get Data From SharePoint Online List or SQL Server

3.     Import a custom visual – ‘PowerApps for Power BI’ from AppSource

4.   Click on the PowerApps icon to use this functionality in the page.

5.   Add relevant data fields to either create a new app or choose an existing app.

6.  Now we are going to choose an app which we have already created using this data source.

7.     Now you would see your PowerApps in POWER BI itself . 

        Just FYI, I am using below screen to SEARCH/INSERT/DELETE data directly in SharePoint List

1                

                                 Isn't it fascinating 🥳🥳

    Once you publish the POWER BI Report, it'll be available at POWER BI SERVICE !!! 

#RR #Day16  #PowerApps #PowerBI #InsertData #UpdateData # DeleteData #SearchData #HappyLearning #WeLearnEveryday