Migrating code from one env toanother

[Anonymous]

I craeted a query for source system, so when I migrate my code to different env I don't have to change source for each table one by one, becuase I have over 10 table in the model. Database is Oracle

Query 1:

let
    Source = Oracle.Database("orcl")
in
    Source

I'm trying to call above query trying to use follwing query for each table (Facts is a table name), so when I migrate to production, all I have to do is change the Query 1.

let
    Source = Oracle.Database(Query1.Fact)
in
    Source

But I'm getting error:

Expression.Error: The name 'Query1.Fact' wasn't recognized.  Make sure it's spelled correctly.

What am I doing wrong here? or is there a better approach to migrating code from one env to another?

Thansk in advance.

[v-ljerr-msft · Accepted solution]

Hi @Anonymous,

If I understand you correctly, you should be able to change your data source under Data source Settings which could be easier in this scenario. 

Option 1: File – Options and Settings

Option 2: Edit Queries Menu

The second option to open the settings dialog is contained in the “Edit Queries” toolbar item menu.

Regards