Forum Discussion
Iterating Queries in Direct Query with Large Excel Pivot Tables
I am creating a semantic model to be connected to Excel and to be used like a cube. It is currently set up as a direct query connection to a snowflake instance. Everything works as expected w...
1. Excel sheets have a limit of 1M rows
2. Excel is NOT a Direct Query data source.
Hi,
In response to 1, row wise the pivot table isn't larger than 1 million rows as one of the larger dimension is being presented across the top/columns.
In response to 2, apologies my wording may have sounded weird. Direct Query data source is snowflake and the front end presentation is being done within Excel Pivot Tables.
