Lookup for Power App embedded in Power Bi report- delegation warning, don't slice/filter the app?

[Rfla]

Hi trying to embed an Power App into Power Bi to write data back to Sharepoint.

But in the the step where I edit the app in the web.powerapps.com solution I get a delegation warning.

Its a simple lookup against a SP list. Using the same syntax as mentioned here:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/powerapps-custom-visual

I have added a column "Id" to the power apps visual in Power Bi.

Giving me the option to use PowerBiIntegration.Data.Id in the lookup...

LookUp(Projectlist,Projectlist.ID=First(PowerBIIntegration.Data).Id)

Worth to mention that I have entered 2000 rows as the Advanced setting option for the app.
Also a Count ID for that project list gives me 862 elements.

The delegation documentation states that SP and Lookup should work for = ?
What am I doing wrong?

[v-micsh-msft · Accepted solution]

Hi @Rfla,

Please take a try to switch the formula as below:

LookUp(Projectlist,ID=First(PowerBIIntegration.Data).Id)

See if this would make any difference.

Regards,

Michael

[Rfla]

Great, that simple change did the trick. Thanks @v-micsh-msft