Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION

@Anonymous There is nothing currently in the tool that would allow you to do this.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

6 REPLIES 6
karaoan
Kudo Commander
Kudo Commander

@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

psolli
Advocate II
Advocate II

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

jrecasens
Frequent Visitor

mikebrunak
Frequent Visitor

Though not PowerBI itself, you can now embed PowerApps within a PowerBI dashboard, and that PowerApp can write back to the database.

hugoberry
Responsive Resident
Responsive Resident

 

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.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors