Access single value of table through power query for OData.Feed

[MujahidAli]

Hey EveryOne.

I have multiple OData.Feed url to retrive data from Dynamics Crm. These are working fine because I used OData Query to fetch select columns. Each url fetches single table so that there are 20+ different url. 

Now I am facing issue while I need to update based url of each odata services url Like I need fetch same data from my production instead of dropbox crm so I will have to replace all 20+ url again which is labourious task. 

I need a solution Like How can I store my base url to any table and access it to OData feed function.

I created a table named ApiLink and tried to used it. but I not working.. error (Expression.Error: A cyclic reference was encountered during evaluation)

let

Source1 = Table.TransformColumnTypes(Source,{{"Link", type text}}) ,
Source = OData.Feed( Source1 & "/ecs_incomegls?$select=ecs_incomeglid,ecs_name", null, [Implementation="2.0"])in
Source

or Something link any global variable to store this url means just kinda global static variable to connection strings.

[v-chuncz-msft · Accepted solution]

@MujahidAli ,

Replace "Source" with the query name or simply use a Parameter.

Table.TransformColumnTypes(Source