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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Danrex
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
v-ljerr-msft
Employee
Employee

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

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

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
Employee
Employee

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.