Forum Discussion

mmickells's avatar
mmickells
New Member
7 years ago

Primary Key's in Power Bi

Our current business software uses an Access database which we would like to pull into Power Bi for reporting needs. I've had little to no experiance with Power Bi in the past so I'm struggling to understand a few things.

 

One main difrence I've found is the Access database appears to have more than one primary key being used with some tables. I've not found a way to have more than one "primary" key in Power Bi. As such I'm having some issues getting our data to pull correctly because I can't seem to build the same type relationships in Power Bi that we have in Access.

 

Is there a way to allow for more than one primary key? If not, what would be the best way to address this issue?

 

Thanks in advance!

 

mmickells

Need Help

2 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    7 years ago

    Hi mmickells ,

     

    To work around the issue, you can create inactive relationship (Close Location= Location) beyond the main active relationship (Open Location= Location) like the picture below, then using USERELATIONSHIP when create measure or column.

     

     

    Best Regards,

    Amy

     

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

     

    • mmickells's avatar
      mmickells
      New Member
      7 years ago

      Hi, v-xicai 

       

      I'm just now been able to circle back around to this, but appreciate your quick responce. We will checking out your suggestion this week to see how it goes! We're pretty new to this Power Bi stuff so we may have more questions. I'll try to respond with an update later this week.

       

      Thanks agian,

       

      mmickells