cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Antonio
Helper II
Helper II

500 rows Limit

Hello,

 

i did a power app application connected to One Drive For Business, this works very well.

But it seems there is still the issue higlithed in the post below .

 

https://powerapps.microsoft.com/en-us/blog/create-an-app-automatically-from-your-data-in-powerapps/

 

So the application is not able to retrieve from the excel file more than 500 items.

 

Do you know if this issue has been solved and how ?

 

Thanks and Best Regards

6 REPLIES 6
rgruian
Power Apps
Power Apps

Antonio,

 

Query delegation is not currently supported for this type of data sources (Excel tables on One Drive), which means your app will cache up to 500 rows locally and all operations will run on/via that cache.

 

Is there a chance you may be able to migrate your data to a different back end that supports query delegation? (for example CDM, or SQL)?

 

Radu Gruian [MSFT] ** PowerApps Staff

Hello,

 

thanks a lot for your reply.

 

Maybe I can migrate the data to an SQL, but do you mean SQL Azure or SQL server ?

 

If so how I can configure the query delegation ?

Thanks a lot

Also,

 

I Have an additional question.

 

This issue is only related to app coming from data ?

 

If I create a blank app and then I link it to an excel file on one drive for business I will have the same issue ?

 

Thanks

 

SQL Server should work fine, as it supports query delegation.

 

There is no need to configure query delegation. PowerApps will automatically detect the server capabilities and will do whatever is needed to ensure that the queries that can run server-side actually get to run there. When this is not possible because of syntactic constructs or semantic constraints, for some specific formula, you will get notified via a "blue icon" suggestion for that formula.

 

Re. your second question: this is orthogonal to App From Data. Query delegation will kick in regardless of what app you are creating, whenever it detects that delegable constructs are supported server-side.

 

Radu Gruian [MSFT] ** PowerApps Staff
Anonymous
Not applicable

Hi Radu!

 

Is there a plan for Dynamics AX (OData) connector to support 'query delegation' and to be able to handle more than 500 items at a time?

 

Thanks,

Gábor

I had 200k+ rows in Excel and when I try to connect to that file as data source PowerApps threw and error saying 2MB limit. So it seems with Excel there is also file size limit in addition to the record count limit.

 

I then imported these to Azure SQL and try to run below and It's not querying all 200k rows to give me the distinct values of my DSM column. So it seem even Azure SQL has some kind of limit. I'm not sure if Distinct function supports delegation but I believe others like SortByColumns & Search do.

 

So why is below query going against Azure SQL not returning all the results?

 

SortByColumns(Search(Distinct('[dbo].[WFGSP_SeedPlan]', DSM), DSMSearchBox.Text, "Result"), "Result", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending))

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

secondImage

Power Apps Community Call

Please join us on Wednesday, October 20th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,358)