cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Danrex New Member
New Member

Insert/Update to SQL Server

I have a client who wants to use power bi but needs to be able to insert and update records in the sql server from Power BI. Is there currently anyway to do this? I suggested embedding Power bi within a web app but they would rather have it the other way around.

Any help would be greatly appreciated
1 ACCEPTED SOLUTION

Accepted Solutions
v-ljerr-msft Super Contributor
Super Contributor

Re: Insert/Update to SQL Server

Hi @Danrex,

 

Using the PowerApps custom visual, you will be able to pass context aware data to a PowerApps app which updates in real time as you make changes to your report. And then you should be able to create a new app to insert and update records back to the sql server. Smiley Happy

 

Reference:

https://powerapps.microsoft.com/en-us/blog/powerbi-powerapps-visual/

https://www.youtube.com/watch?v=-CjGKoXem0I&feature=youtu.be

 

Regards

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: Insert/Update to SQL Server

Hi @Danrex,

 

Using the PowerApps custom visual, you will be able to pass context aware data to a PowerApps app which updates in real time as you make changes to your report. And then you should be able to create a new app to insert and update records back to the sql server. Smiley Happy

 

Reference:

https://powerapps.microsoft.com/en-us/blog/powerbi-powerapps-visual/

https://www.youtube.com/watch?v=-CjGKoXem0I&feature=youtu.be

 

Regards

ns_powerbi Regular Visitor
Regular Visitor

Re: Insert/Update to SQL Server

Hi,

 

Is it possble to use PowerApps in our reports and create a flow where:

A user write in PowerApp custom visual in Power BI Service (reports) > the data goes to a SQL server > then the data will be displayed in our Power BI report.

 

  @v-ljerr-msft