Forum Discussion

Da9's avatar
Da9
New Member
2 years ago
Solved

Integrated PowerApp not showing data

Hi, I'm trying to integrate a PowerApp into a PowerBI report. The app was made using the PBI report to create the PowerBIIntegration control. The control was made with the GUID column for my table, among all the other columns. 

 

When using this formula I don't get any data in the Form when selecting a record in the report. I'm not sure why. It worked before, but all of a sudden stopped:

 

LookUp('Business Needs Problems', 'Business Needs Problems (dwbn_businessneedsproblemsid)' = GUID(First(PowerBIIntegration.Data).'Business Needs Problems'))
 
PowerApp:
 

 

PowerBI:
 

 

Any help would be greatly appreciated.

Need Help
  • Da9's avatar
    Da9
    2 years ago

    Thank you for the reply. I just figured it out. I had to edit the PowerApps visual from PowerBI Service (web), not PowerBI Desktop. Then everything updated with the correct columns. 

     

    Its weird because PowerBI Desktop allows for editing PowerApps visuals, but it would not recognize the columns for me.

     

    Thanks again.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi  Da9 ,

     

    According to your statement, I think you want to integrate PowerApp with Power BI.

    Here I suggest you to refer to below offical blog to learn more details.

    For reference:

    Embed a new Power App in a Power BI Report. - Power BI | Microsoft Learn

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

  • Da9's avatar
    Da9
    New Member
    2 years ago

    Thank you for the reply. I just figured it out. I had to edit the PowerApps visual from PowerBI Service (web), not PowerBI Desktop. Then everything updated with the correct columns. 

     

    Its weird because PowerBI Desktop allows for editing PowerApps visuals, but it would not recognize the columns for me.

     

    Thanks again.