Answered

unable to filter Records from powerBi database

(0) Share

Report

Posted on by rkp1404

HI I have a existing power app created from Microsft list " TerminalNamingQC" which i wish to integrate to Power Bi dashboard using "powerAPps for power BI visual" . so i manage to integrate PBI with Power app and able to see " powerBIintegration".data on my Power app editor .

Also a snip from my PBI dashboard where I filter content using slicer and expecting power app to show only those filter records not all

Can you help how to achieve it .Thanks in advance

br,Rkp1404

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

rkp1404 8 on at

Like (0)

Report
Copy link

Link copied!

Continuing my post .....

-Now adding following formula to "Items" of my "BrowseGalary" , I am able to filter the first Row only .
==> LookUp(TerminalNamingQC,'ID' = First(PowerBIIntegration.Data).'ID')

but i wish to filter all Records that will satisfy 4 of my slicer selected item how to achive it .

Thanks in advance .

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @rkp1404 ,

Please try below formula:

Filter(TerminalNamingQC, 'ID' in PowerBIIntegration.Data.'ID')

Best regards,

Was this reply helpful? Yes No
rkp1404 8 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply , I tried this "Filter "Function but with this i am getting Delegation warning. The highlighted part of this formula might not work correctly on large data sets." . and indeed the filter function is not working correctly because of this warning .

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @rkp1404 ,

You are comparing the two tables using in operator, so you cannot bypass the delegation issue in this case. But to eliminate the warning you can use below formula:

ForAll(PowerBIIntegration.Data As PD, LookUp(TerminalNamingQC , 'ID' = PD.'ID'))

Best regards,

Was this reply helpful? Yes No
rkp1404 8 on at

Like (0)

Report
Copy link

Link copied!

This is superb , now the formular works as per expectation .Thanks for educating me .

Was this reply helpful? Yes No