Forum Discussion

mikebi's avatar
mikebi
Helper III
2 years ago
Solved

options for PowerBI Service writeback to on-premise sql server

Hello, I have a requirement to create a simple writeback where the users can enter an adjustment amount as a number and a comment.    The table will be stored in SQL Server.     They would like ...
Need Help
  • Anand24's avatar
    Anand24
    2 years ago

    mikebi .
    I feel multiple records should also be possible. You will have to device the PowerApp in correct way to do so. I'll suggest you to put your multi-row ask in the PowerApp community where experts will provide an apt solution 🙂

    All you have to do then is embed into Power BI !

    Hope this helps 🙂

SaiTejaTalasila's avatar
SaiTejaTalasila
Super User
2 years ago

Hi,

 

I have seen people using power on .But you need to spend additional cost for using power on.

 

Writeback to Tabluar with both Import mode and Direct query is fully support with Visual Planning from Power ON. Thers is a great video here to get you started. http://poweronbi.com/powerbi-visual-planning/

 

You can also load data from Power BI to SQL with their solutions: http://poweronbi.com/2017/06/power-update-from-power-bi-desktop-to-sql-server

 

Power ON also has a Table Editor that lets you edit SQL Tables in Power BI Service directly. http://poweronbi.com/visual-table-editor/

 

Contact info is [email protected]

 

Visual Planner turns Power BI into a fully fledged Goal Seek and Planning, Budgeting and Forecasting solution.