Primary Key's in Power Bi

[mmickells]

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

[v-xicai]

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]

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