Forum Discussion
PowerBI Integration into Power Apps not working
Hi,
I'm trying to integrate a power apps and power BI to create a system that allows teachers to add comments to their students. I've got a powerBI report that gets all the student and teacher data so that teachers can select the student they want to write comments about in PowerBI, and then am using a sharepoint list to store the comments. I added the power apps visual to powerBI and add the key field that I am also using in my sharepoint list and clicked to create a new app.
I'm now in Power Apps. I've connected a form to the sharepoint list so it will show me the comments, and want to then pass this form the data key field from the powerBI integration to find the comments for the selected student, but it's not recognising the field that I have passed through the PowerBI integration.
Here's the lookup formula I'm using to try and pass the key field from power BI to the form in power apps:
And here's my set up for the visual in PowerBI:
- Anonymous2 years ago
Hi,BenRedmond
Thanks for the quick reply.Regarding the issue you raised, my solution is as follows:
You're right, instead of editing PowerApps visuals from PowerBI Desktop, you need to upload your existing report to the service and edit the PowerApps visuals in edit mode.
Here are screenshots of other users' answers:
Here are links to questions that have similar issues to you:
Solved: Integrated PowerApp not showing data - Microsoft Fabric Community
PowerBIIntegration in Power Apps - Does Not Work F... - Microsoft Fabric Community
Of course, if you have any new ideas, you are welcome to contact us.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
8 Replies
- lbendlinSuper User
You are missing the return value.
Filter, Search, and LookUp functions - Power Platform | Microsoft Learn
- BenRedmondFrequent Visitor
Thanks for your reply, and I'm sure I'm missing something, but I don't understand what you mean by return value. Could you explain in more detail?
Thanks!
- lbendlinSuper User
lookup needs three parameters, you only provided two.