Joining to SharePoint Library on split (delimited) column value

[kevinrpope]

I need to join an existing data model to a SharePoint Document Library, and we'd normally do that using a single-line-of-text column that would have a unique identifier in it that facilitates the join.  Now, we have situations where a single document should be joined to multiple different unique identifiers in the Power BI data model.  I'd rather not use managed metadata with multiple selections if possible, are there other ways to do this?  Can I separate the unique identifiers with a delimiter and split that field when joining?  

Thanks!

[v-yanjiang-msft]

Hi @kevinrpope ,

It's hard to reproduce your problem in my side, but you can try to split the column by delimiter, refer to the document: Split columns by delimiter - Power Query | Microsoft Docs

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.