Power BI – Extract Multiple Sources at one time

Power BI – Extract Multiple Sources at one time

Extracting multiple sources at one time in Power BI can require setting up multiple sources and appending the datasets together.  However, if you know the “M” language a little or you can review the following screenshot, you will be able to Append the sources together without having to create multiple sources.

Caveats:

  1. The field names in the Table.Combine (Append) should be identical (including case sensitive), otherwise additional columns will be created.
  2. Make sure each line in the editor has a different name (IE, each Source should be unique to ensure nothing is overwritten)
2018-09-24T09:55:03-04:00