Hi all, I have an issue with locally stored SSAS tabular model in Visual Studio (let's name it Model_2 for purpose of convenience). Any change in code (change of metric description or definition) takes at least 2 minutes to calculate and when creating calculated table it takes >4 minutes. Compatibility level 1200, Microsoft Visual Studio Professional 2019 Version 16.11.17 x32 bits (latest version of VS 2019) Integrated Workspace Mode = True What's important that once tabular is deployed, it's performance is satisfying. Only locally, when using model stored in a Disk Space it is causing an issue. Other people within organisation has the same issue when using this code version. Model is 1.9GB which is not a lot in comparison to other projects we run with no issue One of previous version of code (Model_1), which is working smoothly, does not contain one additional data source and 4 tables from this data source. It also does not contain metrics folders and descriptions for metrics/tables/columns. After removing data source and tables from latest version (Model_2) models' performance didn't improve, which may indicate that these additional tables are not cause of this issue. Deleting workspace file "model_bim_<username>.settings" helped but only for couple of changes. Copying model.bim from Model_2 to Model_1 caused the same issue which may indicate that model.bim contains some bugs, but as I compared it in Tabular Comparison tool I didn't spot any other diffrence than described in point 6. Do you have any idea what should I check in order to fix it? Thanks in advance! P.

Visual Studio - SSAS tabular - long time of implementing changes in model locally

Piotr Rybinski 1

Hi all,

I have an issue with locally stored SSAS tabular model in Visual Studio (let's name it Model_2 for purpose of convenience). Any change in code (change of metric description or definition) takes at least 2 minutes to calculate and when creating calculated table it takes >4 minutes.

Compatibility level 1200, Microsoft Visual Studio Professional 2019 Version 16.11.17 x32 bits (latest version of VS 2019)
Integrated Workspace Mode = True
What's important that once tabular is deployed, it's performance is satisfying. Only locally, when using model stored in a Disk Space it is causing an issue.
Other people within organisation has the same issue when using this code version.
Model is 1.9GB which is not a lot in comparison to other projects we run with no issue
One of previous version of code (Model_1), which is working smoothly, does not contain one additional data source and 4 tables from this data source. It also does not contain metrics
folders and descriptions for metrics/tables/columns. After removing data source and tables from latest version (Model_2) models' performance didn't improve, which may indicate that these
additional tables are not cause of this issue.
Deleting workspace file "model_bim_<username>.settings" helped but only for couple of changes.
Copying model.bim from Model_2 to Model_1 caused the same issue which may indicate that model.bim contains some bugs, but as I compared it in Tabular Comparison tool I didn't spot
any other diffrence than described in point 6.

Do you have any idea what should I check in order to fix it?
Thanks in advance!

Tianyu Sun-MSFT 29,446 Reputation points Microsoft Vendor

2022-07-15T14:07:36.97+00:00

Hi @Piotr Rybinski , does VS work well before? Do you use any extension? Do you set some special configurations?

Only locally, when using model stored in a Disk Space it is causing an issue.

Do path(like path name is too long…), file location(if save files/models in other drive will this issue disappear?) affect the performance?
Piotr Rybinski 1 Reputation point

2022-07-15T14:18:40.79+00:00

Hi @Tianyu Sun-MSFT ,

Yes, VS is working well now, but not for this one particular version of project. I am also working on another project and VS has no issues with it.
I think changes I did was to turn Integrated Workspace Mode from True to False and then again to True.

Regarding extensions is use SQL Server Analysis Services (of course) and Oracle Developer Tools for Visual Studio, but nothing really changed here.

File path is not so long C:\ and then 6 folders up. When I rollback previous version from versioning software it is in exactly same location and it works smoothly.
Tianyu Sun-MSFT 29,446 Reputation points Microsoft Vendor

2022-07-19T07:12:59.817+00:00

Hi @Piotr Rybinski ,

I believe there must be something newly added(in Model_1) which cause this issue. Can you find any other differences between Model_1 and Model_2 project? Maybe configuration differences, cache files/folders differences and model.bim file differences? I know you have checked this, but your description and test exactly indicates that the key is hidden in the differences. Besides, does versioning software has modified information recorded?

Share via

Visual Studio - SSAS tabular - long time of implementing changes in model locally