Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
PhilBackPack
New Member

(perhaps a version bug?, pls see details) - RELATIONS - Cardinality issue arose suddenly...

Hi, this is a weird issue :

 

1. I use a PBI Desktop version 2.103.881.0 64-bit (mars 2022)

2. My client uses a PBI Desktop version 2.xxx.xxx.x 64-bit (juillet 2023) (sorry I forgiot to make a note of the digits)

 

Both our versions are in French (we are in France)

Both I and my client use the same data source, we just tested this a moment ago together, from scratch

 

The issue :

i.1 on my side I can define a 1many-to-1 (*:1) / "A sens unique" (unidirectional) relation between 2 of the tables

i.2 when my client tries doing the same, PBI does not propose the option "unidirectional", but only "bidirectional" or options specifically naming the 2 tables, and he can not set any of the types (*:1) etc etc... he gets a message saying "cardinality error etc"

 

We both followed the exact same click and drag procedure on the modelisation diagram

 

Another weird difference is that on my PBI version I can create a tabular visual merging data from the 2 tables (and prior to having defined any relation), but my client cannot : on his (juillet 2023) version, PBI returns an error message as soon as one tries to drag a field from the second table into the first table's visual...

Has anyone experienced this and did anyone find a fix ?

 

Supplemental note:

Before the month of July 2023, my client was able to create relations (*:1)/unidirectional; the issue arose for him a couple days ago (I trust after his PBI cversion got automatically updated/upgraded to the "Juillet 2023) version he has now

This is a critical issue : my client is in production and all of a sudden everything gets stalled.

Thank you for your very much appreciated help if you have a solution

Cheers.

Phil

1 REPLY 1
PhilBackPack
New Member

I forgot to post illustrations : Here is what happens correctly on my side :

1.jpg

My client is currently busy in a meeting, I'll post a pic of what happense on his side asap, sorry...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

Find out what's new and trending in the Fabric community.