Forum Discussion

jracer007's avatar
jracer007
Helper IV
8 years ago

Add multiple data sources in PowerQuery

Hello,

As I can add several sources of JSON data to Power Query, they are the same url only the code (11500475788) is the one that changes. The idea is to take all the sources without having to create them one by one.

14 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    Sure, just add additional Source lines, just make sure they are named uniquely, Source1, Source2, Source3, etc. I do this all the time when creating Merge and Append queries.

    • jracer007's avatar
      jracer007
      Helper IV

      Could I take the url from a column from another data source? They are more than 300 sources and are constantly growing.

      • Greg_Deckler's avatar
        Greg_Deckler
        Community Champion

        Not sure I understand your question. Can you clarify?