How to Integrate Power Apps with Power BI
In this tutorial, we will demonstrate how you can incorporate a Power App directly into your Power BI report and make the two interact together.
In PowerApps:
Remove the Gallery
Create a Form
Unlock the controls on the form
Form Items Property
LookUp('Employee Training', Title=First(PowerBIIntegration.Data).EmployeeNo)
Form Default Mode
If(CountRows(Filter('Employee Training', Title=First(PowerBIIntegration.Data).EmployeeNo)) = 1, FormMode.Edit, FormMode.New)
Default Property of the EmployeeNo Object
First(PowerBIIntegration.Data).EmployeeNo
Default Property of Date Field
Now()
Button
OnSelect Property
SubmitForm(Form1); Refresh('Employee Training')
Create a Rectangle
Create a label - Text = Please select a record to activate
Create a Group - Instructions
Visible Property of group = If(CountRows(PowerBIIntegration.Data) = 1, false, true)
Save and Publish the App