Refresh data source view in SSAS

• Baskar B.V

  SSCrazy

  Points: 2823

  More actions

  March 17, 2010 at 9:04 am

  #139503

  Hi All,

  I have created a data source view in SSAS project connected to some tables in database x. After i created them there are some changes to the schema of the tables in database x. How to reflect those changes in my data source view. I tried to refresh but i was not able to see the changes. do i need to remove the table and add them again?

  Appreciate your reply.

  Thanks

  [font="Arial"]BASKAR BV
  http://geekswithblogs.net/baskibv/Default.aspx
  In life, as in football, you won’t go far unless you know where the goalposts are.[/font]

• Paul White

  SSC Guru

  Points: 150468

  More actions

  March 18, 2010 at 5:04 am

  #1135835

  Menu: DataSource View --> Refresh

  Alternatively, there is a small refresh icon at the top left of the design window.

  Paul White
  All articles available on SQL.kiwi
  @SQL_Kiwi

• Cary Davis

  SSC Veteran

  Points: 265

  More actions

  August 3, 2010 at 12:23 pm

  #1201734

  Thanks you just saved me tons of time!

• singhraj4u 82078

  Valued Member

  Points: 55

  More actions

  July 5, 2013 at 5:28 am

  #1630022

  Some occasion you get "Unable to prepare" under Change column. I had a situation where I changed the view name from vw_abc to vwabc and after that upon clicking refresh button I got "Unable to prepare" message.