Write back to the Database from Power BI using PowerAppsVisual

In this article, we will see how we can write back the data to the SQL database using a PowerApp visual in Power BI

The most impressive thing about Microsoft is, how they listen to their customer's requests and add the features, this is one of the great features that Microsoft added to the Power BI visuals using which

There are various scenarios where business users need this feature to update the data through the Power BI Interface. Some of them are like updating Expected Target Values, Forecast and adding Comments to the individual rows in the report

Following illustration shows the data flow

Now let's see a step by step process to create a Power BI Report that can write back the data to the SQL Database

Step -1: Provision an Azure SQL Database

1. Sign in to the Azure portal and create an Azure SQL Database with the below details

2. Connect to the newly created DB and run the below script

CREATE TABLE tblStudent

(