Forum Discussion
Error when creating a relationship
You probably should not have to do this but a last resort would be to add a unique ID column and just give a number. You would then have to use that record along with all the entries in your source tables. Again, a little bit of trouble now but it may save you some headaches later.
If I make a unique ID, what am I matching it up to? Neither the fact or dim tables have a unique ID. So if I make a unique ID on the fact table, how does that help me relate records in the dim table?
You would have to change the entries in the dim and fact tables to use the ID instead of the actual name for this to work. You would really be building a more traditional relational database. Again, may not be worth the time. I have seen a couple of articles cautioning against trying to recreate a database structure in PowerBI. There is probably a much smarter way to do it.