Forum Discussion

VickyMarga's avatar
VickyMarga
Frequent Visitor
3 years ago

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 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

Need Help

3 Replies

    • VickyMarga's avatar
      VickyMarga
      Frequent Visitor
      3 years ago

      Hi, thanks.

       

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

      • Charrington2's avatar
        Charrington2
        Regular Visitor
        3 years ago

        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!