Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

write back

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
Status: Needs Votes
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/
alden_lee2
New Member
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.
Doskamp
Advocate I
I 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.
per_solli1
New Member
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.
bradley_zorns
New Member
Please add a write-back functionality to Power BI in order to support financial planning models.
walted
New Member
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
r_lemmens
New Member
I need this to 'play' with suggested changes to my data.
prashantkaushal
New Member
The Write-back to database capability from Power BI table visual is very important to including forecasting information
mkreider
New Member
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.