cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AndrewGeddes
Level: Powered On

Power BI slowing PowerApp form load

All,

 

I've got a PowerApp embedded in a report that's passing over some selection information to filter the app in both info display and form. The issue - the form takes forever to load due to the size of the PBI file.

 

Is it possible to limit what PowerApps sees from PBI? All I need is what's selected in real time in the PBI dashboard to filter the PowerApp (gallery or form fields x 2)

 

Any thoughts here?

6 REPLIES 6
Dual Super User
Dual Super User

Re: Power BI slowing PowerApp form load

Hi @AndrewGeddes 

 

In your gallery in PowerApps - set items property to First(PowerBIDataIntegration.Data)

AndrewGeddes
Level: Powered On

Re: Power BI slowing PowerApp form load

This will affect the edit form on a separate screen? The gallery seems to load okay. When launching the form is where I run into issues. 

Dual Super User
Dual Super User

Re: Power BI slowing PowerApp form load

Hi @AndrewGeddes 

 

what is the item propery of the form control - it should be gallery.selected

 

how many controls are on this form?

AndrewGeddes
Level: Powered On

Re: Power BI slowing PowerApp form load

Two controls attached to PBI integration, 5 to a SharePoint list (that's currently empty).

 

The formula on the two fields attached to PBI to get the current state is:

 

LookUp('SharePoint List',Time=First(PowerBIIntegration.Data).'Time').Time

 

and

 

LookUp('SharePoint List',Location=First(PowerBIIntegration.Data).'Location').Location

Dual Super User
Dual Super User

Re: Power BI slowing PowerApp form load

Hi @AndrewGeddes 

 

 

LookUp('SharePoint List',Time=First(PowerBIIntegration.Data).'Time').Time

 

First(PowerBIIntegration.Data).'Time' - can be replaced with Gallery.Selected.Time

 

LookUp('SharePoint List',Location=First(PowerBIIntegration.Data).'Location').Location

First(PowerBIIntegration.Data).'Location' - can be replaced with Gallery.Selected.Location

 

Not sure if it will speed it up but will not be querying your data source again to get first value - this will directly get info from gallery

 

Highlighted
AndrewGeddes
Level: Powered On

Re: Power BI slowing PowerApp form load

Thanks Reza, unfortunately, it didn't really change much. Still very (very) slow loading. Is there a way to only load that control in real-time as selected in Power BI? Where right now it appears to be attempting to tackle the entire data set?

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (10,013)