Forum Discussion
Write back options in Power BI with SSAS tabular model
The method used in the link you shared involves using Power Apps and making use of the Power Apps custom visual or the application this particular website is attempting to sell. Power BI itself isn't doing any write backs, but is simply surfacing up a Power Apps solution. Its Power Apps (and flow) that would be handling any of the data updates. The Power On app i have no experience with, but it likely has its own limitations. I'm unsure what access these apps have to the data within the report it is surfaced within, if any.
akj2784 From our experience implementing planning systems, I would question if it's a good idea to write back directly to an SSAS Tab database. This has a variety of problems (particular refresh performance) associated with it. I would look into options to use a relational data base in direct query mode with SSAS for the budgeting/planning tables and implement write back to those. You might find this solution https://wwww.acterys.com that offers business users web based editing of the model, generating Power BI models and reports as well as a variety of write-back and planning options from Power BI and Excel helpful.