cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gauthambr
Level: Powered On

Data Update and Insert new records using PowerApps from Power BI report

Folks,

Can someone help me with the below requirements?
#1 The ask is Business users need to UPDATE (existing records in Azure SQL DB) and INSERT (new records to Azure SQL DB) through PowerApps from the Power BI report (app.powerbi.com).
#2 Once data are updated & inserted the refresh needs to happen immediately and the changes need to be visible in the Power BI report.

The architecture we are following is Azure SQL DB ➔ Azure Analysis Services (Tabular) ➔ Power BI report.

** Immediately after the data insert & update is done, the changes needs to be refreshed in Azure Analysis Services and then it should reflect in Power BI report.

 

Thanks in advance!

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Data Update and Insert new records using PowerApps from Power BI report

Hi @gauthambr ,

Do you want to add and update records in your Azure SQL Table within single one canvas app rather than separated apps?

 

Based on the needs that you mentioned, please check if the following video would help in your scenario:

https://www.youtube.com/watch?v=193b7T_p35M

 

On your side, you could consider generate a PowerApps app based on your Azure SQL Table firstly, then the generated app would be consists of thres screens -- Browse Screen, Detail screen and Edit screen. You could use this app to add or update records in your SQL Table.

More details about generating an app based on SQL Table, please check the following video:

https://www.youtube.com/watch?v=eqaEVsh4byQ

 

After that, when you add PowerApps Custom Visual in your Power BI report, please select "Choose app" option rather than "Create new" option, then choose your above generated app from your PowerApps Environment:4.JPG

 

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: Data Update and Insert new records using PowerApps from Power BI report

Hi @gauthambr ,

Do you want to embed an canvas app into a Power BI report?

Do you want to use the embedded canvas app in a Power BI report to update/create records in your Azure SQL DB, and then changes should be immediately visible in your Power BI report?

 

Firstly, if you want to embed a canvas app into your Power BI report, then use the embedded app to create/update records in your Azure SQL DB, please check the following article or video for mode details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual

 

https://www.youtube.com/watch?v=-CjGKoXem0I

https://www.youtube.com/watch?v=3eiUR8Lo4i4

 

On your side, you should add a PowerApps Custom Visual in your report based on your Azure SQL DB dataset, then you could create a new or add existing canvas app into your Power BI report.

 

In addition, if you want the changes you made (through embedded app) to your Azure SQL DB dataset to be visible in your Power BI report immediately, I afraid that there is no way to achieve your needs in PowerApps currently.

Currently, it is an known limit with the PowerApps Custom Visual in Power BI -- The PowerApps custom visual can't trigger a refresh of Power BI reports and Power BI data sources from within Power BI Desktop. If you write back data from the app to the same data source as the report, your changes won't be reflected immediately in Power BI Desktop. Changes are reflected on the next scheduled refresh.

Please check the following known limits for PowerApps Custom Visual for more details:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual#limitations-of-...

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gauthambr
Level: Powered On

Re: Data Update and Insert new records using PowerApps from Power BI report

@v-xida-msft 

Thanks for the response!

Can you please guide me to do both INSERT and UPDATE the existing data in a single PowerApp to Azure SQL DB? I couldn't figure out a way to achieve it.

I can only able to do in 2 separate apps.

Community Support Team
Community Support Team

Re: Data Update and Insert new records using PowerApps from Power BI report

Hi @gauthambr ,

Do you want to add and update records in your Azure SQL Table within single one canvas app rather than separated apps?

 

Based on the needs that you mentioned, please check if the following video would help in your scenario:

https://www.youtube.com/watch?v=193b7T_p35M

 

On your side, you could consider generate a PowerApps app based on your Azure SQL Table firstly, then the generated app would be consists of thres screens -- Browse Screen, Detail screen and Edit screen. You could use this app to add or update records in your SQL Table.

More details about generating an app based on SQL Table, please check the following video:

https://www.youtube.com/watch?v=eqaEVsh4byQ

 

After that, when you add PowerApps Custom Visual in your Power BI report, please select "Choose app" option rather than "Create new" option, then choose your above generated app from your PowerApps Environment:4.JPG

 

Please take a try with above solution, check if the issue is solved.

 

Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

C_Chrisstov
Level: Powered On

Re: Data Update and Insert new records using PowerApps from Power BI report

The safest way to go is use a NewForm control for the Insert action and an EditForm control for the Update.

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,912)