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 sho...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

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

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