cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
PowerAppNovice
Level: Power Up

Searching data from PowerBI Integration (more than 2000 rows)

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!

2 REPLIES 2
Community Support Team
Community Support Team

Re: Searching data from PowerBI Integration (more than 2000 rows)

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:

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

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
PowerAppNovice
Level: Power Up

Re: Searching data from PowerBI Integration (more than 2000 rows)

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!

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (5,086)