Putoch
asked on
How to refresh tabular model to reflect changes on underlying table source
Hi,
I am working with a tabular model in Visual studio SQL SERVER 2017 and one of my underlying source table has changed design.
I would like to refresh the table on my model so that this change is updated on my tabular model.
When i look this up there are lots of references (https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/refresh-the-schema-in-a-data-source-view-analysis-services#bkmk_DSVrefresh) ,
to go to the DSV (data source view) but i don't see data source view under solution explorer -
If i click on the 'data source' under tabular model explorer but there is no refresh option.
I tried processing the database on full since someone mentioned that as a solution (https://stackoverflow.com/questions/54708558/how-to-update-tabular-data-from-source-tables)
but i'm still getting an error
I would appreciate any help or advice on this please?
Thank you
I am working with a tabular model in Visual studio SQL SERVER 2017 and one of my underlying source table has changed design.
I would like to refresh the table on my model so that this change is updated on my tabular model.
When i look this up there are lots of references (https://docs.microsoft.com/en-us/analysis-services/multidimensional-models/refresh-the-schema-in-a-data-source-view-analysis-services#bkmk_DSVrefresh) ,
to go to the DSV (data source view) but i don't see data source view under solution explorer -
If i click on the 'data source' under tabular model explorer but there is no refresh option.
I tried processing the database on full since someone mentioned that as a solution (https://stackoverflow.com/questions/54708558/how-to-update-tabular-data-from-source-tables)
but i'm still getting an error
I would appreciate any help or advice on this please?
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.