Forum Discussion
Solved
Combine data from two different sources in the same query?
Is it possible to merge data from two different data sources within the same query, something like: Source1 = Json.Document(Web.Contents("https://rsq-tm.com/cqweb/oslc/repo/MYschema/db/CCP/qu...
Sure, use a Merge or Append query, the M function is Table.Join.
Sure, use a Merge or Append query, the M function is Table.Join.
Table.Join is equivalent to SQL-JOINS (with all options as well!).
What you need here is Table.Combine({Source1, Source2}) (or Append if you do it via the UI). This is the equivalent to the SQL-UNION.
