Forum Discussion
Modifying underlying data
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
HI mcquillank.
No, it is impossible.
Power bi only support get data from datasource, it not contains any writeback functions.
Regards,
Xiaoxin Sheng
3 Replies
HI mcquillank.
No, it is impossible.
Power bi only support get data from datasource, it not contains any writeback functions.
Regards,
Xiaoxin Sheng
That's unfortunate, but is the answer i expected.
Thanks for the reply
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 [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.
Per Solli
