Modifying underlying data

[mcquillank]

Novice user here. I have a PowerBI spreadsheet set up which takes its data from inputs made through a power app in Dynamics 365. Normally, data is inputted in the PowerApp and can be displayed in PowerBI. However, I would like to be able to also modify the underlying data in PowerBI (some users, myself included, don't like the power app as an input tool and would prefer to work exclusively with PowerBI).

Is it possible to do this?

Thanks

[psolli]

Writeback to Tabluar/SQL 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 feedback@poweronbi.com
 
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.
 
Per Solli

[Anonymous · Accepted solution]

HI @mcquillank.

No, it is impossible.

Power bi only support get data from datasource, it not contains any writeback functions.

Regards,

Xiaoxin Sheng

[mcquillank]

That's unfortunate, but is the answer i expected.

Thanks for the reply