Skip to main content

Power BI

Needs Votes

Custom limit in DirectQuery

Vote (7) Share
Juan Alvarado's profile image

Juan Alvarado on 09 Feb 2018 21:26:39

Right now if we try to retrieve more than a million rows, give an error and cant handle it. The documentation said this is a limit for performance, but think is better if we can limit in configuration that limit, some analysis like telcos or banking need retrieve more than a million rows

Comments (1)
Juan Alvarado's profile image Profile Picture

Henrik Widforss on 24 Mar 2023 09:10:41

RE: Custom limit in DirectQuery

This is possible if you have a Premium capacity:https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-premium-workloads#max-intermediate-row-set-count