Share via

How to repoint ODBC datasource from one database to another so underlying tables can get refreshed?

ANIRBAN Nag (IN) 1 Reputation point
2022-09-05T05:47:20.507+00:00

I have a Tabular Model project (Azure Analysis Services Level 1500) in Visual Studio 2019. I have set up my odbc datasource to connect to my Snowflake server. From there I am able to import tables and view data too. My requirement is, currently I am connecting to DEV database and all the tables are coming from DEV. Is there anyway I can change in only one place to repoint it to TEST env and all the underlying tables will fetch data from TEST env.

Only place I could found this can be achieved by clicking on the Source Data of Table Properties. But this have to be done for each and every table then. I want a one place change solution.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
444 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. HimanshuSinha-msft 19,386 Reputation points Microsoft Employee
    2022-09-06T21:35:31.55+00:00

    Hello @ANIRBAN Nag (IN) ,
    Thanks for the question and using MS Q&A platform.
    As we understand the ask here is how to update the data source to point to different database , please do let us know if its not accurate.
    You should be able to update the data source under the data source .

    238346-image.png

    Please do let me if you have any queries.
    Thanks
    Himanshu

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
      • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators