Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
HI @mcquillank.
No, it is impossible.
Power bi only support get data from datasource, it not contains any writeback functions.
Regards,
Xiaoxin Sheng
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
69 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |