web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Filter delegation Azur...
Power Apps
Answered

Filter delegation Azure DataWarehouse

(0) ShareShare
ReportReport
Posted on by maxsnow 33

Hi Guys

 

I have a table in Azure Datawarehouse with ~50k records.

 

In PowerApps I created a collection with filter function

 

FILTER('Table', email = user().email)

It appears that the app brings 500 records in memory and then applies the filter.

It does not do filtering on ADW side.

 

Does it mean PowerApps do not delegate filtering to ADW or I am doing something wrong?

 

Thank you,

Max

Categories:
Building Power Apps
I have the same question (0)
  • Verified answer
    v-xida-msft Profile Picture
    v-xida-msft Microsoft Employee on at

    Hi @maxsnow,

    Currently, within PowerApps, the Azure Data Warehouse is not a Delegable data source.

    More details about Delegable data sources supported within PowerApps, please check the following article:

    https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-list

    In default, if the data source is not a Delegable data source, you need to move your data into your app for processing locally, and you could only process 500 records at most locally. You could also consider change the "Data row limit for non-delegable queries" limit to 2000 (maximum value) within Advanced settings of App settings, then you could process 2000 records locally.

    In order to get rid of 500 records Delegation limit, as an alternative solution, please check and see if the following blog would help in your scenario:

    https://blog.coeo.com/davidmorrison/powerapps-500-record-limit-delegation-and-how-to-work-around-it

     

    Best regards,

    Kris

  • AndresP1 Profile Picture
    AndresP1 10 on at

    Hi. Nowadays, does an Azure hosted SQL database works as an on-premises SQLserver connector in terms of delegation? Because I am having delegation warnings with simple filter or sum functions.

    Thanks a lot!

    Andrés.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities
The Next Big Bite | Aussie Classics & Starting Small with Clay Wesener | EP04

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 325 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 88 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans