Forum Discussion

lcannon's avatar
lcannon
Frequent Visitor
7 years ago

Changing Live Connection to Tabular Model

When I change a report to connect to a new SSAS Tabular Model (in data source settings), the report seems to be maintaining a background connection of some sort to the old model as well.  The following things are happening when I try to add a new measure:

1) it's telling me that it can't find the home table, even though I built the measure within the table in the new model (it's looking for the home table from the old model)

2) It's telling me the name of the measure I'm writing already exists in another table (from the old model).  

 

Is there a way to remove the old model so that I do not need to completely rebuild the report that took about 80 hours to develop?

 

 

Need Help

1 Reply

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    7 years ago

    You are able to add measures to a report that are not part of the SSAS tabular model.  They exist only in the report but they are still attached to tables that exist (or existed) in the model and I think that is what you are running into.  Try adding an empty table called Home to the new SSAS tabular model.  I am betting that the measure you wrote in the report that are attached to the home table will show up.  Then you can move them to where they should be and finally delete the home table.

    If you can, always add your measures to SSAS model in visual studio.  That way they are available to every tool and report that connects to the model.