Skip to main content
Microsoft Idea

Power BI

Needs Votes

Write Back functionality without SSAS

Vote (36) Share
Patrick Sura's profile image

Patrick Sura on 02 Apr 2015 14:25:22

Write Back functionality without SSAS Cube?

To create a simple forecast and to input data manually, it would be great to use write-back functionality only with a Power Pivot Workbook.

Comments (2)
Patrick Sura's profile image Profile Picture

Power BI User on 05 Jul 2020 23:10:33

RE: Write Back functionality without SSAS

This is already possible: if you are looking for basic collection of simple cell input the PowerApps integration could be an option. For serious planning and business modelling functionality, you might want to have a look at: www.agilityplanning.com This solution offers sophisticated write back and planning for Power BI and Excel. In addition to writing to a relational table the solution offers a powerful OLAP in-memory engine on top of SQL Server that caters for large scale multi user write back requirements that typically don't work with sufficient performance if you just write to a relational table.

Patrick Sura's profile image Profile Picture

Diederick on 05 Jul 2020 23:06:40

RE: Write Back functionality without SSAS

same as Idea:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20395300-write-back