Add a data sample size as an optional setting in Configuration Manager for SSAS Tabular
When working with large tables in SSAS Tabular (as it is not always possible to develop on a sample of prod data), I am forced to use a hard coded filter (eg TOP n) in my source query to avoid sucking all data into my model at design time I then have to modify the partition query(s) post deployment meaning whats in my solution doesnt match the code on the server. To alleviate this work around, if an optional sample size setting were able to be configured in the Configuration Manager it could be set to filter a top "n" of records when using my "Dev configuration" and be set to not filter at all in my "Prod configuration".
Paul Hales
shared this idea
1 comment
-
Paul Hales
commented
Update: I understand it is possible to remove the Top n in the partition query however, this is still not ideal as any change to the table "properties"query will clobber the table "partition" query if there is only a single partition.
