Searching data from PowerBI Integration (more than 2000 rows)

[PowerAppNovice]

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!

[v-yutliu-msft]

Hi @PowerAppNovice ,

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

[PowerAppNovice]

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!