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

(0) Share

Report

Posted on by Rfla

252

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?

Categories:

Building Power Apps

All responses (7)

Answers (1)

Sort by

Verified answer

v-micsh-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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 252 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

Hi I am having similar issue.

Below is the formula I am trying to implement but is not working.
LookUp('52 Weeks Tamper plan', ID = First(PowerBIIntegration.Data).Id)

Any help would be appreciated.
OreoluwaAdebayo on at

Like
a
(0)

Report
Copy link

Link copied!

You got a solution yet
kanwals360 on at

Like
a
(0)

Report
Copy link

Link copied!

No Sadly not yet.
HorejsiPower 13 on at

Like
a
(0)

Report
Copy link

Link copied!

Mine looks the same as yours @kanwals360 . I can get the formula to work with 'Title', but it doesn't like 'ID'.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone have any hints on this, I have the same issue and after entering the . after (PowerBIIntegration.Data).XXXX I don't get any selection options for the XXXX and nomatter what I type in it's not taking it. Seems to refer to an incompatible comparison. The ID field is the same as what's in the Sharepoint list and the form is tied to the same list.