Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Can power BI be used as an interface to update a database with values? Say you have a sales database connected to Power BI, and you use Power BI for the visualizations. Can you also use Power BI to put data back into the database, say you create a form through Power BI and want to update with new monthly sales data?
Thanks
Jacob
Solved! Go to Solution.
@Anonymous There is nothing currently in the tool that would allow you to do this.
@Anonymous you might want to have a look at: https://www.acterys.com it offers comprehensive write-back and planning functionality (e.g. top down/bottom) from Power BI for structured and unstructured data (rich text editor) into MS SQL tables.
It also enables uers users to edit star schema models and add extensive financial logic templates (3 way forecasting) with Azure SQL or with SQL Server on premise. With the cloud based option you can get started in minutes without extensive installation requirements.
Martin
Hi,
Power SQL is a part of Power Update. It can export all or one table in a power pivot in Excel or Power BI desktop to a SQL database.
https://powerpivotpro.com/2015/09/power-query-as-an-ssis-alternative
See the last option.
Email feedback@poweronbi.com
Though not PowerBI itself, you can now embed PowerApps within a PowerBI dashboard, and that PowerApp can write back to the database.
Nothing standard for sure.
I've managed to push data into a database from Power Query https://querypower.com/2017/04/04/exporting-power-query-tables-to-sql-server/. But pushing it from the report view would require a custom visualization and some web api' and hacking.
Do you really need to use a reporting solution for data import?
@Anonymous There is nothing currently in the tool that would allow you to do this.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
15 | |
15 | |
13 | |
12 | |
11 |