Skip to main content

Power BI

Needs Votes

SQL Server Analysis Services Cubes write-back

Vote (105) Share
Brian Searle's profile image

Brian Searle on 23 Oct 2015 18:28:30

This depends on having the SQL Server Analysis Services Cubes connector implemented. But now work has started on that I wonder if it will include write-back functionality. This would be ideal for financial planning and budgeting solutions in PowerBI.

Comments (7)
Brian Searle's profile image Profile Picture

Brian Searle on 05 Jul 2020 23:31:40

RE: SQL Server Analysis Services Cubes write-back

This is also mentioned here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12903954-support-for-ssas-writeback-functionality

Brian Searle's profile image Profile Picture

Diederick on 05 Jul 2020 23:06:40

RE: SQL Server Analysis Services Cubes write-back

I highly support this idea. It already has been posted a few times.
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20395300-write-back

Brian Searle's profile image Profile Picture

TomMartens on 05 Jul 2020 22:37:39

RE: SQL Server Analysis Services Cubes write-back

'@sebastian there are two flavors of write-back dimension write-back (create new members), this feature is deprecated, but the other flavor cell-writeback to SSAS measure groups is still a much needed capability in financial or sales related planning budgeting scenarios

Brian Searle's profile image Profile Picture

sebastian on 05 Jul 2020 22:34:47

RE: SQL Server Analysis Services Cubes write-back

in the major sql server release after sql server 2016 it´s planned not to continue e.g. with the write-back functionality of dimension values (announced to be deprecated), which will completely disable the possibility of having manually set comments by the data. how this integrates with the need of having write back capabilities in the reporting layer as requested here?

Brian Searle's profile image Profile Picture

Juerg H. on 05 Jul 2020 22:32:28

RE: SQL Server Analysis Services Cubes write-back

I totally agree - customers doing financial planning and budgeting ask for write-back options.

Brian Searle's profile image Profile Picture

Zakria Malik on 05 Jul 2020 22:27:42

RE: SQL Server Analysis Services Cubes write-back

Any update on this? Would be nice if there is a way that data can be written back on a sharepoint list or excel file.

Brian Searle's profile image Profile Picture

Power BI User on 05 Jul 2020 22:17:15

RE: SQL Server Analysis Services Cubes write-back

Any updates or feedback? Thanks!