How to enable left join with mysql group concat csv merged instances of right side column values

Question

Any insights on how to address the power bi power query?

Answer 1

You can look for this:

 

let
    Source = Table.NestedJoin(#"mysqldb support_request", {"id"}, #"mysqldb support_request_tag"[[#"support_request_id"], [#"tag_name"]], {"support_request_id"}, "tag_name_csv", JoinKind.LeftOuter),
    #"Transformed tags" = Table.TransformColumns(Source, {{"tag_name_csv", each Text.Combine(_[#"tag_name"], ", "), type text}})
in
    #"Transformed tags"