It would be great to write back functionality in Power BI so that users in PowerBi desktop or PowerBI web service can write back to an SQL server database or to a Sharepoint list. It is very important when planning budgeting, budget follow-up and forecasts
17 Comments
- JUERG_H
Advocate I
For the purpose of corporate performance management as budgeting and the simulation of scenarios, write back functionality is a must. Espacially the guys from the Financial Controlling Dept. would apreciate it very much! Often the lack of this feature is the reason why companies cannot rollout Power BI licenses in all of their business units. Perhaps Microsoft should think of acquiring something like https://www.tagetik.com/ - Agree with Juerg. I work in a corporate accounting department. We are currently using Adaptive Insights because it has the writeback capability for budgeting and forecasting.
DoskampI currently use the writeback functionality of SSAS in combination with Excel. But it would be a next step to use PowerBI. An example of a vendor who is already developing a solution is PowerOnBI. But rolling it out in large organizations would be much easier if Microsoft supported and developed this technology.- Hi, There are two great options for write back for both row level SQL editing in Power Apps, and more Corporate Performance Mangement functionality in Visual Planner from Power ON. Both works great. http://poweronbi.com/2018/01/write-back-options-in-power-bi/ Per
- Mitsql
Advocate II
Currently using powerapps for writeback but it would be really nice to see the functionality within Power BI Desktop and Web, where we can combine direct query and writeback feature. - Please add a write-back functionality to Power BI in order to support financial planning models.
- Yes please. The Powerapp embedded visual is a step in this direction, but the user experience remains poor. We need to emulate the same simple user experience as people have when they edit data in Excel
- I need this to 'play' with suggested changes to my data.
- The Write-back to database capability from Power BI table visual is very important to including forecasting information
- It would also be nice to have write back capability for manually entered tables so that the data could be entered directly from table and matrix table reports in Power BI Desktop instead of going through the "Enter Data" dialog. Entering data directly in a matrix table instead of the "Enter Data" dialog would add powerful context making it much easier to populate a user defined table.
