Search code examples
ssasssas-tabular

SSAS Tabular How to Change the connection of a table


I created a Tabular model using VS 2013 (because later versions don't support BIDS helper (which we use for creating a folder structure organizing all measures and dimensions within the model)). After working on it for a while I noticed that I was missing a table, so I went back to go get it. The only mistake which I made was that I ended up creating a new data connection in the process. Short of dropping those tables and recreating them, is there a simple way for me to change the data source of that new table so that I can delete the redundant connection to my database?


Solution

  • A colleague shared the following link: http://jakubka.blogspot.com/2013/11/how-to-change-connection-string-for.html.

    While changing the code in this way most certainly comes across as being hacky and is probably not the highly recommended way to do things; it worked! Took me less than 5 minutes to fix and it was as simple as described in the link...

    Jakub K (author of the article), thanks, man!