Forum Discussion

BenRedmond's avatar
BenRedmond
Frequent Visitor
2 years ago
Solved

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 d...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.


 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 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.