Tabular - no dsv? how to change data source of single table?


  • I have a single connection that pulls through 3 tables (fact, 2 dims)

    I now need to change the source of ONE of the dims to a view on a different server/database

    How do i do this? deleting the dim from the model isn't an option as it'll break relationships/dax/measures etc etc

    The only way i can think of is to use the database the source is currently pointing to as a 'dsv' and create a view that uses linked servers to pull the data from the new dim on the new server.database, but this seems like an awful solution!

    Do i need to go into the xml manually change stuff? is that even possible?

    Jakub @ Adelaide, Australia

    Friday, November 01, 2013 4:46 AM