Forum Discussion
Solved
Change Data Source but Keep Models and Visualizations
Hello, I am using DirectQuery to get data from a data warehouse that we built that we are constantly making updates to. We currently have a single data warehouse that we are connected to, made mo...
I like this approach for automation, thanks for suggesting the approach. For manual updates I just use the Change Source dialog in Data Source Settings:
Hi CJ,
best practice for this scenario is to use a parameter for your connection-string to the database (or at least for the database name) that you use/reference in all your queries.
That way you only have to change the parameter once and all your data that uses/references this parameter will be switched to the new datasource at once.