Power BI Write Back to Database with Power Apps

[VickyMarga]

Hello everyone, 

i have a question using Power Apps:

I have a table in SQL where I have to add values by selecting the line using power apps:

When i select a row the visual of power apps show me the row and allows me to add a new value, and save.

After save i want to see the new value in live ? 

someone could help me? 

thanks

[amitchandak]

@VickyMarga , that is tricky for import mode, as you have refresh data (Desktop) or schedule refresh (Service)

[VickyMarga]

Hi, thanks.

I need write back option with Power Apps in Power BI in the SQL table 

[Charrington2]

Hi Vicky,

The only way I have found to do this, is by adding a Direct Query in your PowerBI model, to read the SQL table you're writing to.

Then from PowerApps when you do the save, you need to call the command:
PowerBIIntegration.Refresh();
This will refresh (not reimport but just refresh the data) which will trigger the read again from the Direct Query, showing in PowerBI the data you justed posted on SQL.

Seems a basic scenario, but it'S not there by default, you need these pieces in order to make it work.

Hope it helps.

Did I answer your question? Mark my post as a solution!