Forum Discussion

carH's avatar
carH
Helper I
5 years ago
Solved

Change the data source information in Advanced Editor

Hello, I'm connecting to a DB2 database. I have connected to a test file in a test library. I have since changed the data source in the Advanced Editor to the Production Library & File.  I want to co...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi carH ,

     

    Based on your description, I think it is enough to change the "source" part as long as you are sure that the content edited later also exists in the new data source.

    You can just change the data source in Power Query Advanced Editor or change it in “Data source settings”.

     

    If you have two or more tables which are from the same datasource , I suggest that you could choose the latter method . It is more convenient .

     

    Hope that's what you were looking for.

    Best Regards,

    Yuna

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi carH ,

 

Based on your description, I think it is enough to change the "source" part as long as you are sure that the content edited later also exists in the new data source.

You can just change the data source in Power Query Advanced Editor or change it in “Data source settings”.

 

If you have two or more tables which are from the same datasource , I suggest that you could choose the latter method . It is more convenient .

 

Hope that's what you were looking for.

Best Regards,

Yuna

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • carH's avatar
    carH
    Helper I
    5 years ago

    Thank you, Yuna.