PowerApps integration with PowerBI - loads item for several seconds

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.