Write calculated PowerBI column back to database automatically

[JohannSteyn]

Hi all,

(I'm new to this forum)

I want to build a PowerApp to simply write back a calculated column in PowerBI to our database. (I understand I need to use PowerApps - that's why I'm new here), but it looks like manual intervention is needed with PowerApps (i.e. a user must click submit before the data is written to the database).

Does anyone have an idea on how to automatically write back "submit" calculated columns to the database on a schedule (this seems like a very simple task but I have spent the last 7 hours searching for a solution)

Thanks in advance

[v-qiaqi-msft · Accepted solution]

HI @JohannSteyn,

Which data based do you want to write back?

Do you want to write back a calculated column in PowerBI to a database like excel or SharePoint?

Firstly, you should open the report in Edit mode in Power BI service and click on the Power App visual.

1). First select the fields you want to make available to the app

2). Always create a new app or use an app that you have previously created from Power BI service. Here I suggest you create a new app

3). Create a new app and in Power Apps Studio, take a look at what is created for you. On top of Screen1, you see PowerBIIntegration. 

4). Add a second screen to edit selected items from the Galley. Go to the Home tab and click on New Screen and choose Form.

A form has two important properties:

• Data Source: This is the table that will get updated. Even though the fields are already coming from the Power BI report, you must connect the form to your database like SQL data source for it to be able to write changes back to the table
• Item: This is where the form gets its fields populated from. Here you should set it as Gallery1.Selected

5). So far we have a form that is showing the selected item from the Gallery. Once the data is saved, we want the app to refresh the Power BI report and the app to navigate to the first screen. Modify the OnSelect property to look like this.

SubmitForm(EditForm1);PowerBIIntegration.Refresh();Navigate(Screen1);