Forum Discussion
Large dataset options for reporting server
I'm looking at building a large report (>100M rows) and I can't seem to find a good workign strategy on report server. On premium this is easy using deployment pipelines, or incremental refresh, etc...
There is not really a good solution for this on Report Server alone. What we do with models of this size is to build them as SSAS tabular models. Then we can use deployment tools and partitions for incremental processing and we just create pbix reports in live connect mode to SSAS. If you have SSAS on a separate server (which is a good idea to spread the load) you just need to ensure you have Kerberos setup.