In Paul Turley’s blog post
PowerON BI – Write-back to Power BI and SSAS tabular for forecasting and planning
I’ve used the Power Update tool from Power On in the past. When I saw the Power Planner demonstrated, the simplicity and ease-of-use just knocked my socks off. The ability to write-back forecast data and report on real-time “what-if” scenarios has been a difficult to achieve holy grail in the Microsoft BI space but these guys have it right. The concept is amazingly simple: in a Pivot Table, change the total of any calculated or aggregated measure. The contributing details and subtotals are proportionally recalculated and written back into the model’s data source and then then refreshed. Large models using SSAS tabular use small partitions to isolate changes. We’ve built custom solutions to address specific user requirements using a similar architectural approach (with considerable effort) but this tools seems to be flexible enough for different use cases. They’ve also created custom visual that allow data changes to be applied using Power BI visual charts and tables. Quite nice.
We are excited to be working closely with Paul and his team, and we are lining up demos for his clients.
The Power ON Team