Hi @milky_bar_may ,
Do you want to patch Power BI data from your Power BI report to your SP list?
Based on the needs that you mentioned, I think the PowerApps Custom Visual in Power BI report could ahieve your needs. On your side, you could consider embed an canvas app into your Power BI report using PowerApps Custom Visual.
When you select record from other visual (e.g. Table) in your Power BI report, the corresponding record data would be transfered into the embedded canvas app through PowerBIIntegration control.
Within your embedded app, you could consider add a Gallery control, set the Items property to following:
PowerBIIntegration.Data
then the selected records from your Power BI report would be displayed in this Gallery. Within this Gallery, you could add some Label controls, set the Text property to following:
ThisItem.Column1
ThisItem.Column2
ThisItem.Column3
...
to display the column value of these selected records from your Power BI report.
After that, if you want to patch the displayed records value in your Gallery back to your SP List, I think the Patch function could achieve your needs. You could add a "Submit" button (in same screen as above Gallery) within your embedded canvas app, set the OnSelect property to following:
ForAll(
Gallery1.AllItems,
Patch(
'YourSPList',
Defaults('YourSPList'),
{
Column1: Label1.Text,
Column2: Label2.Text,
Column3: Label3.Text,
...
}
)
)
Note: The Label1, Label2, Label3, ... represents Label controls in above Gallery.
More details about embedding a canvas app into a Power BI report, please check the following video:
https://www.youtube.com/watch?v=b9gBXUdd55M
https://www.youtube.com/watch?v=xhFQxS6VRws
Best regards,
