web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps PowerBIIntegration Del...

Power Apps

Unanswered

PowerBIIntegration Delegation Problem Workaround

(0) Share

Report

Report

Posted on by hanna3

Hi. Is there a workaround in my delegation problem below? When I select an EmployeeNumber in Power BI, it does not show in Power Apps. It says that it may not work in large datasets.

Here is the code.
LookUp(*SP List Name*, EmployeeNumber = First(PowerBIIntegration.Data).EmployeeNumber)

Thank you.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (0)

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @hanna3 ,

This problem has arisen recently. The reason is PowerBIIntegration.Data as data source is non-delegable now. You can set First(PowerBIIntegration.Data).EmployeeNumber OnStart of App in a variable:

Set(varENr,First(PowerBIIntegration.Data).EmployeeNumber)

or use a With function instead to eliminate the delegation warning:

With( {wENr:First(PowerBIIntegration.Data).EmployeeNumber}, LookUp(*SP List Name*, EmployeeNumber = ENr) )

Best regards,

Join the conversation