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
Icon for Community Support rankCommunity 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
Icon for Resolver I rankResolver 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: