Iterating Queries in Direct Query with Large Excel Pivot Tables

Hi delks,

Thank you for reaching out to Microsoft Fabric Community Forum.

This behavior is expected in DirectQuery mode, especially when dealing with large pivot tables in Excel. Power BI generates separate queries for each unique combination of filter values to optimize performance. However, when there are too many combinations, it results in excessive queries to Snowflake, causing performance issues.

Ensure indexes and clustering are optimized for the queried dimensions.

Use Materialized Views for pre-aggregated data to reduce query complexity.

Run Performance Analyzer to check which queries are being sent.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
Vinay Pabbu