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 :
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.