Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago
Solved

Write back options in Power BI with SSAS tabular model

Hi All,   We have a tabular model based on SSAS which gets the data from Oracle db, and we are using that as a source in Power BI. We have a use case where we want to write the data back to db and...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

     

psolli's avatar
psolli
Advocate II
8 years ago

Hi,

 

Writeback to Tabluar with both Import mode and Direct query is fully support with Visual Planning from Power ON. Thers is a great video here to get you started. http://poweronbi.com/powerbi-visual-planning/

 

You can also load data from Power BI to SQL with their solutions: http://poweronbi.com/2017/06/power-update-from-power-bi-desktop-to-sql-server

 

Power ON also has a Table Editor that lets you edit SQL Tables in Power BI Service directly. http://poweronbi.com/visual-table-editor/

 

Contact info is [email protected]

 

Visual Planner turns Power BI into a fully fledged Goal Seek and Planning, Budgeting and Forecasting solution.

 

Note: We support Notes at tuple level in the models as well.

 

VP uses it's own, 5 year in development, write-back engine to SSAS Tabular and SQL/Oracle/Hana/Teradata.

 

Per Solli