web
You’re offline. This is a read only version of the page.
close
Skip to main content

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