Insert/Update to SQL Server

[Danrex]

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

[Anonymous]

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

[v-ljerr-msft · Accepted solution]

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. 

Reference:

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

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

Regards