Multiple Merge

[Anonymous]

Hi, All.

Seeking for your expertise is that possible that I can merge all of this into one? 

Ann

[wdx223_Daniel]

Table.Combine(Record.ToList(Record.SelectFields(#shared,List.Select(Record.FieldNames(#shared),each Text.StartsWith(_,"T_Duplicates ")))))

[mussaenda]

Hi @Anonymous ,

What is your source data?

If you just one to merge them in power query, You can append them all as one table and disable the load of the data

[foodd]

A practical solution would be to create a View upstream using SQL, and then connect to the View with Power BI?

If this is not practical, then please tell us more about the data source and connection types.  Please describe in plain language the business logic,  other transformations necessary, and the desired results.    There is not sufficient information from your description and image of several queries to provide an educated guess at this time.  If you were to share your work-n-progress Power BI file, we could have a more meaningful conversation about a solution.