PowerBI Integration into Power Apps not working

[BenRedmond]

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:

[lbendlin]

You are missing the return value.

Filter, Search, and LookUp functions - Power Platform | Microsoft Learn

[BenRedmond]

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!

[lbendlin]

lookup needs three parameters, you only provided two.

[BenRedmond]

Maybe I'm misunderstanding it, but the third parameter is optional, and given that I want to return the entire record from the sharepoint list that corresponds to the key field I passed from power bi, the documentation you posted suggests that I shouldn't include the third parameter.what am I missing?

[BenRedmond]

I've also tried using a gallery with a filter command instead of a lookup, so no third parameter to worry about, and that gives the same error: that the STUDENT_CLASS_ID is not recognised. That is what I do t understand, be used that is the field I am passing from PowerBi.

Sorry, I'm new to power apps, so I'm just trying to get my head around why this doesn't work.

[v-linyulu-msft]

Thanks for the reply from lbendlin , please allow me to provide another insight:

Hi, @BenRedmond 

Regarding the issue you raised, my solution is as follows:

1.First, make sure that the STUDENT_CLASS_ID field in the Power BI and SharePoint lists is of the same data type. If not, you may need to convert them to the same type.
 

2.Then, you can try changing it to the following code:

LookUp(ACADEMIC_REVIEWS_COMMENTS,STUDENT_CLASS_ID=Value(First(PowerBIIntegration.Data).STUDENT_CLASS_ID))

3.Next, you need to check that your PowerBIIntergration.data contains the Data on your side. You can hover your mouse over this code, where you can see the table return:

4.Finally, you need to check that it contains the "STUDENT_CLASS_ID" column name from the PowerBIIntergration.Data table:

5.Here are some links that may help you with similar questions:

Solved: PowerApps LookUp formula (powerplatform.com)

Solved: lookup function in PowerApp has an error even when the datatypes are same (powerplatform.com...

6.Here is the relevant documentation:
Filter, Search, and LookUp functions - Power Platform | Microsoft Learn
First, FirstN, Index, Last, and LastN functions - Power Platform | Microsoft Learn
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.

[BenRedmond]

Thanks Leroy, that's really helpful.

The problem seems to be that the PowerBiIntegration has no data in it:

Is there a way to fix this? I've had a look at the solution here: Solved: Powerapps Visual- No Data in PowerBIIntergation.Da... - Microsoft Fabric Community but that doesn't seem to work for me. Is it a license-level thing? Or does the PowerBI report need to be published first?

[v-linyulu-msft · Accepted solution]

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.