Forum Discussion
Power BI Write to database?
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
6 Replies
Though not PowerBI itself, you can now embed PowerApps within a PowerBI dashboard, and that PowerApp can write back to the database.
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 [email protected]
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 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
