Forum Discussion
jracer007
8 years agoHelper IV
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_DecklerCommunity 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.
- jracer007Helper IV
Could I take the url from a column from another data source? They are more than 300 sources and are constantly growing.
- Greg_DecklerCommunity Champion
Not sure I understand your question. Can you clarify?