Forum Discussion
Error when creating a relationship
Hello, I am trying to create a relationship between all my tables using "account name unique" (which should be unique), and my other tables, such as "account name" in the opportunity table (it's a Z...
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.