Merge 2 queries directly from 2 API calls (without creating tables)

[Anonymous]

Hi, 

I am trying to merge these 2 queries, but dont know the syntaxis, could you help me please?

let

   Query1 = let

   Source1 = Json.Document(Web.Contents("https://api-v2.intrinio.com/securities/AAPL/historical_data/52_week_high?frequency=daily&start_date=...")),

   Source2 = Json.Document(Web.Contents("https://api-v2.intrinio.com/securities/AAPL/historical_data/52_week_low?frequency=daily&start_date=2..."))

in

Source1,

   historical_data = Query1[historical_data],

   #"Converted to Table" = Table.FromList(historical_data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

   #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"date", "value"}, {"date", "value"}),

   #"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",{{"value", "High"}})

in

#"Renamed Columns"

let

   Query2 = let

   Source1 = Json.Document(Web.Contents("https://api-v2.intrinio.com/securities/AAPL/historical_data/52_week_high?frequency=daily&start_date=...")),

   Source2 = Json.Document(Web.Contents("https://api-v2.intrinio.com/securities/AAPL/historical_data/52_week_low?frequency=daily&start_date=2..."))

in

Source2,

   historical_data = Query1[historical_data],

   #"Converted to Table" = Table.FromList(historical_data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

   #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"date", "value"}, {"date", "value"}),

   #"Renamed Columns" = Table.RenameColumns(#"Expanded Column1",{{"value", "Low"}})

in

   #"Renamed Columns"

[v-frfei-msft]

Hi @Anonymous ,

Based on my test, We cannot call multi api at the same time. As in Power query, we can only get the data step by step. So, althought your code is ok, but you cannot get the excepted result. You can try to come up a new idea and add your comments there to make this feature coming sooner.
https://ideas.powerbi.com/forums/265200-power-bi-ideas