Forum Discussion

nes_k4's avatar
nes_k4
Copper Contributor
Dec 03, 2021
Solved

Download two tables from web in one function query

Hello, I wanted to ask if it's possible to download two tables from a list of URLs in one single query? Please refer to the attached file. I have a list of URLs for different stock codes. At the mom...
Excel for web
power bi
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Dec 03, 2021

    nes_k4 Change the applied step in fxOther where you initially filter one table to this:

    #"Filtered Rows" = Table.SelectRows(Source, each ([Id] = "cnhk-list" or [Id] = "cnhk-list2")),

     Now the function will load both tables and create one bigger table.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Dec 03, 2021

nes_k4 Change the applied step in fxOther where you initially filter one table to this:

#"Filtered Rows" = Table.SelectRows(Source, each ([Id] = "cnhk-list" or [Id] = "cnhk-list2")),

 Now the function will load both tables and create one bigger table.

Resources