Forum Discussion
unsignedInt Error Excel PT
Hi delks,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The issue you're facing is because Excel tries to load all unique values of a field when you use it in the filter section, but the field you're using has around 4 million unique values. Since your semantic model uses DirectQuery to Snowflake, there’s a default system limit that allows only up to 1 million rows in any query result (including intermediate steps). When Excel tries to retrieve those 4 million values, it exceeds this limit, which causes the error messages you’re seeing. While your admin can technically increase this limit, they’re usually hesitant because it can slow down the system, overload the data source, and increase costs. A better solution is to avoid using high cardinality fields in filters and instead place them in rows with some filtering, or create a grouped version of the column that reduces the number of unique values. Alternatively, limit the data at the source level so Excel has fewer values to process.
Best regards,
Prasanna Kumar
Hi delks,
Thank you for reaching out to the Microsoft Fabric Forum Community.
The issue you're facing is because Excel tries to load all unique values of a field when you use it in the filter section, but the field you're using has around 4 million unique values. Since your semantic model uses DirectQuery to Snowflake, there’s a default system limit that allows only up to 1 million rows in any query result (including intermediate steps). When Excel tries to retrieve those 4 million values, it exceeds this limit, which causes the error messages you’re seeing. While your admin can technically increase this limit, they’re usually hesitant because it can slow down the system, overload the data source, and increase costs. A better solution is to avoid using high cardinality fields in filters and instead place them in rows with some filtering, or create a grouped version of the column that reduces the number of unique values. Alternatively, limit the data at the source level so Excel has fewer values to process.
Best regards,
Prasanna Kumar