Forum Discussion
Developing SSAS Tabular Model on Subset of Data
How do I develop a SSAS Tabular Model against a subset of my data? If I try to pull in all of the data, I run out of RAM on my machine (and even if I don't run out of RAM, iterative R&D is slow)?
>If any of the tables in your model will contain a large number of rows, consider importing only a subset of the data during model authoring. By importing a subset of the data, you can reduce processing time and consumption of workspace database server resources.
Ideally I can develop against a subet of the data (so it runs quickly and I don't exceed local RAM) but then I publish the full model to Azure Analysis Services that use the full datasets.
I am currenlty using Visual Studio for development.
Hi arothberg ,
Based on the description, when importing new tables, try to filter the data to include only a subset.
Besides, you can click Expressions to use query to select the table.
You can also view the following document to learn more information.
Add a table to an Analysis Services tabular model | Microsoft Learn
Import data by using a native query (Analysis Services) | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi arothberg ,
Based on the description, when importing new tables, try to filter the data to include only a subset.
Besides, you can click Expressions to use query to select the table.
You can also view the following document to learn more information.
Add a table to an Analysis Services tabular model | Microsoft Learn
Import data by using a native query (Analysis Services) | Microsoft Learn
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.