topic Insert/Update to SQL Server in Developer

Insert/Update to SQL Server

Danrex — Mon, 19 Feb 2018 01:23:16 GMT

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

Re: Insert/Update to SQL Server

v-ljerr-msft — Tue, 20 Feb 2018 07:19:48 GMT

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

Re: Insert/Update to SQL Server

Anonymous — Fri, 19 Oct 2018 07:15:56 GMT

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