Forum Discussion
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 un...
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.
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,
