cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Migrated_User
Solution Sage
Solution Sage

256 rows limit

Content migrated from TechNet.  Post attribution to: Marcelo111

I connected to adventure database on azure sql, and it seems like I can only access tables, not views, and there is a 256 rows limit.
Is that by design? will it change in the future? Is there any order used when applying this limit to  the data?
Marcelo

1 ACCEPTED SOLUTION

Accepted Solutions
Migrated_User
Solution Sage
Solution Sage

There is a 5000 row limit so we're not sure why you are only seeing 256 rows.  The Product Group is looking into it. And yes, Views are not supported we are working on it.

Thanks,

Harold


Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Harold Kless Microsoft Online Community Support

View solution in original post

8 REPLIES 8
Migrated_User
Solution Sage
Solution Sage

Hi Marcelo,

For this issue, I'm trying to involve someone familiar with this topic to further look at it.

Best Regards,

Wendy

Migrated_User
Solution Sage
Solution Sage

There is a 5000 row limit so we're not sure why you are only seeing 256 rows.  The Product Group is looking into it. And yes, Views are not supported we are working on it.

Thanks,

Harold


Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread. Regards, Harold Kless Microsoft Online Community Support

View solution in original post

Migrated_User
Solution Sage
Solution Sage

I tested different datasources and there was a limit of 256 in the beginning. Now the limit is gone. Problem solved.  5000 is plenty. Thank you.

Marcelo

Migrated_User
Solution Sage
Solution Sage

Hi, returning 5000 rows is fine, but can we select or use t-sql to decide which 5000 records are returned? My table has over a million records and I'd like to display a few hundred of those in list.

I am still experiencing the 256 row limit (to Azure Sql Server Database).

 

What resolved this in order to get the 5000 row limit?

Hello dreeddri.  My understanding is that 5000 rows will never be returned, please see this latest update on delegation:

https://powerapps.microsoft.com/en-us/tutorials/function-sort/#delegation

It is clear that the intention is to return at most 500 rows (and this is the case today for SharePoint lists), but like you I also manage to retrieve only 256 rows from Azure sql (actually Access Web App, but it is the same back-end)

The fact is that if delegation eventually works as intended then 500 or even 256 rows are more than enough since by filtering and sorting you can show the user only the needed portion of your data and do aggregate functions (sum, average etc.) over the whole dataset.

The problem is that in my experience delegation is not yet working, and I would be grateful if anyone could give an example of delegation actually working.

An additional bonus would be to return not just tables but also queries of an Azure sql database, but this is also functionality planned for the future.

Please let me know if anything is not clear or you think needs correction.

I agree that the ability to connect to queries would be a huge step forward in making apps based on relational databases (SQL SERVER) practical.  The combination of a 255 - or even 500 or even 5000 - row limit before filtering will make many applications impossible.  I understand one can setup one's own restful API, but it is extraordinarily frustrating to have the SQL connection there and not be able to see views or create direct queries.

 

I think this deserves top priority.  Thanks

This is no longer a limit if the expression is delegable to server. If the expression is not delegable then limit is 500 rows. You can find more information about delegation at below link.

 

https://powerapps.microsoft.com/en-us/tutorials/delegation-overview/

 

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,224)