Unanswered

Searching data from PowerBI Integration (more than 2000 rows)

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I've connected my PowerApp to a current PowerBI data source which has a large amount of data on it. On the PowerApp I have 2 fields that are pulling from it: Agency Code & Agency Name. The user types agency code and it autofills the agency name based on a lookup formula from the PowerBI data source. The issue I'm having is that it's not searching for all of the rows in that datasource. It's only pulling a small portion of that data so when the user searches for an agency code that's far along the list, it won't find a match to populate the agency name.

The formula I'm using to populate Agency Name is :

If(Len(AgencyCodeBox.Text) = 6,LookUp(PowerBIIntegration.Data, 'Transaction Agency Code' = AgencyCodeBox.Text, 'Transaction Agency Name'),"Agency Name")

Does anyone have an idea how to overcome this limitation?

Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you mean that powerapps could only pull a small portion of data, at most 2000 records?
Well, it is PowerApps itself limit, not PowerBI Integration limit.

Could you tell me what is your app's data source?

PowerApps could only deal with at most 2000 records in local.

If the record number is larger than 2000, the app will not perform well (may get wrong result).

This is called delegation problem.

To avoid delegation problem, here are two ways:

1)only use delegateable data source and delegateable functions

For now, we only support three delegateable data sources:

Common Data Service

SharePoint

SQL Server

You could click the data source that you want to see delegateable functions. Different data source has different delegateable functions.

2)save the data in collection, use collection as data source

In collection, it will not have delegation problem.

Here's a doc about delegation for your reference:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your reply!
So I'm using powerbi integration to connect to a PowerBI dataset (SQL Analysis Services connection) as well as a sharepoint list which has 0 rows atm. In PowerBI I have a table which has Agency Code and Agency Name. By typing the agency code, it autofills Agency Name. However, it only knows about around 2000 of these agencies.

I'll take a look at collections. Thank you again!

Was this reply helpful? Yes No