Manage Relationship and joining a table on a csv column.
In our datawarehouse we have a Product Table and a Tag Table. One product can have multiple tags. I'm trying to figure out how to join the two based on the TagID column in the product table being a comma separated value. I'm looking for help on how to possibly join these tables and/or if it's easier how to change the table structure in the warehouse to make this work. My goal is to be able to have a drop down filter of all Tag Descriptions so that someone can pick a tag and see the product information that's tied to that tag.
Any advice on how to use tags in power bi and in data warehouse architecture would be greatly appreaciated.