Forum Discussion

cjgonzalez's avatar
cjgonzalez
Regular Visitor
8 years ago
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...
Need Help
  • mow700's avatar
    mow700
    8 years ago

    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:

     

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
8 years ago

Hi cjgonzalez,

 

You can try to open a new Power BI desktop window, then get data from production data warehouse in DirectQuery mode, go to Query Editor -> Advanced Editor, copy the Power Query here. Then go to the report you want to change data source, paste this Power Query in Advanced Editor. 

 

 

Best Regards,
Qiuyun Yu 

  • mow700's avatar
    mow700
    Resolver I
    8 years ago

    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: