PowerApps integration with PowerBI - loads item for several seconds

[Jakub32]

Hello,

i have PowerApp integration in PowerBI report. In PowerApps i have form which is also connected to SharePoint, where PowerBI gets data from SQL. 

Idea is to load item into form from selected item and update changes into SharePoint. My problem is that when i select item in my PowerBI it takes 5 or more seconds to load into PowerApps form. Its important to say, that this report contains thousands of records. 

Is there any way to speed this up? I think that this is happening due to PowerBIIntegration component in PowerApps and due to high number of records. I mostly using lookups in my PowerApps form.

For item of form i use:

LookUp('output-defect-triage', HeaderID=First(PowerBIIntegration.Data).HeaderID)

Datasource: SharePoint list

For each column in form i use something like this in Default:

First(PowerBIIntegration.Data).HeaderID

Thank you in advance.

Jakub

[Jakub32]

Thank you very much for guidance and clarification.

[v-saisrao-msft · Accepted solution]

Hi @Jakub32,  

Thank you for reaching out to the Microsoft Fabric Forum Community. 

Regarding the performance challenges when integrating PowerApps with Power BI, this delay is a known issue, especially with large datasets. This is due to how PowerBIIntegration handles data and how PowerApps queries SharePoint.  

As the @christinepayton, mentioned using page-level or visual-level filters in Power BI can help reduce the data transferred to PowerApps. This is crucial because PowerBIIntegration does not support delegation, meaning it only processes the data selected in Power BI at that moment. If too many records are passed, it can result in longer load times.  

• Implement filters in Power BI to ensure only the necessary records are transferred to PowerApps, rather than the entire dataset. Additionally, if feasible, aggregate data in Power BI to minimize the number of records that PowerApps needs to handle.  
• Rather than conducting multiple lookups across different form fields, store the selected record in a variable once and reference it throughout the form. When working with a large SharePoint list, explore methods to reduce the number of queries to SharePoint, as frequent lookups can degrade performance.  
• If your SharePoint list is extensive, ensure that the HeaderID column is indexed to enhance lookup speeds. Additionally, minimize the number of columns retrieved to reduce data processing overhead.

If this post helps, please give us ‘Kudos’ and consider accepting it as a solution to help other members find it more quickly.

Thank you.

[christinepayton]

If you add some page level or visual-level filters to filter down the quantity of data that's sent at the page load time, that will help. But the integration doesn't use delegation in the same way that the normal app connection does, so if you send it everything in your model it'll probably be slow.