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

Writeback to database using Power app with Power BI interactive

Hi All,

 

I have created Power App using Power App studio. I have made interaction between Power App and Power BI using PowerBIIntegration function. App contains Edit form and source for this form is SQL database table. Now what function I should use to read data coming from PowerBIIntegration? Attaching the screen captures which makes more clear about it.

 

Can any one please help me to resolve this issue.

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Writeback to database using Power app with Power BI interactive

Hi @Jagan1 ,

Could you please share a bit more about your scenario?

Do you embed an canvas app within your Power BI report?

Which data set does your Power BI report connects to? Is it also the SQL Table?

 

Firstly, there is no additional function should be used to read data from PowerBIIntegration control when you edit the canvas app from your Power BI report. When you type following:

PowerBIIntegration.Data

within the Items property of the Gallery, the data would be populated automatically as below:9.JPG

please make sure there have some records existed in your SQL Table already. Then within the Gallery, you could add some Label controls within it, then set the Text property to following:

ThisItem.Column1
ThisItem.Column2

...

then the corresponding data from the data set in your Power BI report would be populated within your Gallery.

 

Then within your Detail screen, set the Item property of the Display form to following:

LookUp(StudentInfo, Sname = BrowseGallery1.Selected.Sname)

10.JPG

On your side, you should type:

LookUp('[dbo].[Powerapp]', PrimaryKeyColumn = BrowseGallery1.Selected.PrimarykeyColumn)

Note: The PrimaryKeyColumn represents the Primary Key in your SQL Table.

Within your Edit screen, set the Item property of the Edit form to above formula:

LookUp('[dbo].[Powerapp]', PrimaryKeyColumn = BrowseGallery1.Selected.PrimarykeyColumn)

Note: If you have already embedded your canvas app within your Power BI Report, when you Edit your canvas app individually within PowerApps Studio for web (rather than edit your app from your Power BI Report), the PowerBIIntegration would not return any data.

If you want to edit your embedded canvas app within your Power BI Report, please consider edit your canvas app from your Power BI report as below:11.JPG

rather than edit your canvas app individually from your PowerApps Studio for web.

 

More details about embedding a canvas app within a Power BI Report, please check and see if the following videos would help in your scenario:

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

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

 

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

1 REPLY 1
Community Support Team
Community Support Team

Re: Writeback to database using Power app with Power BI interactive

Hi @Jagan1 ,

Could you please share a bit more about your scenario?

Do you embed an canvas app within your Power BI report?

Which data set does your Power BI report connects to? Is it also the SQL Table?

 

Firstly, there is no additional function should be used to read data from PowerBIIntegration control when you edit the canvas app from your Power BI report. When you type following:

PowerBIIntegration.Data

within the Items property of the Gallery, the data would be populated automatically as below:9.JPG

please make sure there have some records existed in your SQL Table already. Then within the Gallery, you could add some Label controls within it, then set the Text property to following:

ThisItem.Column1
ThisItem.Column2

...

then the corresponding data from the data set in your Power BI report would be populated within your Gallery.

 

Then within your Detail screen, set the Item property of the Display form to following:

LookUp(StudentInfo, Sname = BrowseGallery1.Selected.Sname)

10.JPG

On your side, you should type:

LookUp('[dbo].[Powerapp]', PrimaryKeyColumn = BrowseGallery1.Selected.PrimarykeyColumn)

Note: The PrimaryKeyColumn represents the Primary Key in your SQL Table.

Within your Edit screen, set the Item property of the Edit form to above formula:

LookUp('[dbo].[Powerapp]', PrimaryKeyColumn = BrowseGallery1.Selected.PrimarykeyColumn)

Note: If you have already embedded your canvas app within your Power BI Report, when you Edit your canvas app individually within PowerApps Studio for web (rather than edit your app from your Power BI Report), the PowerBIIntegration would not return any data.

If you want to edit your embedded canvas app within your Power BI Report, please consider edit your canvas app from your Power BI report as below:11.JPG

rather than edit your canvas app individually from your PowerApps Studio for web.

 

More details about embedding a canvas app within a Power BI Report, please check and see if the following videos would help in your scenario:

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

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

 

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

Helpful resources

Announcements
thirdimage

Power Automate 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

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

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