Forum Discussion
Power BI Write Back to Database with Power Apps
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 sho...
Hi, thanks.
I need write back option with Power Apps in Power BI in the SQL table
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!