Is doing a right join to filter bad practice?

Hi akhaliq7 ,

I would strongly advise against using merges for anything that can be avoided.

For your scenario, i.e. creating dimension tables from fact tables, I would just create a new blank query something like this:

Table.Distinct(
    Table.SelectColumns(
        factQueryName,
        {"ID column name", "desciption column name"}
    )
)

If you just want to cut down a table based on values in another table, I would use a buffered list comparison, something like this:

Table.SelectRows(
    Table/QueryName,
    each List.Contains(
	    List.Buffer(referenceTable[columnWithFilterValues]),
	    tableToFilter[columnName]
    )
)

Pete