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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
GAN2
New Member

Cardinality relationship no correctly applied

Good morning, 

I have a relationship many to one, from TsrResult Links to Timesteps. The Editor shows the correct direction (many to one) but the arrow is not being drown in the correct direction and the measures are showing the results expected by the arrow. The only workaround I found is either puting the relationship as many to many and choose the direction or either putthing the direction in both directions

 

GAN2_1-1732006939393.png

 

1 ACCEPTED SOLUTION
danextian
Super User
Super User

Hi @GAN2 

 

It can be confusing but one to many or many to one are essentially the same and in a single direction relationship, the relationship always flows from the one to the many side.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand 

 

Timesteps, being a dimension table, why would you want the fact table to filter it?

danextian_1-1732016487358.png

danextian_2-1732016653991.png

 

danextian_0-1732016075450.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

View solution in original post

3 REPLIES 3
123abc
Community Champion
Community Champion

 

Please follow folling link.

 

Relationship troubleshooting guidance - Power BI | Microsoft Learn

 

Solved: the cardinality you selected isn't valid for this ... - Microsoft Fabric Community

 

Cardinality relationship not correctly applied in Power BI - Search

 

OR follow below step to troubleshoot your issue:

 

I think you’re encountering a visual glitch in Power BI with the cardinality relationship between TsrResult Links and Timesteps. Here are a few steps you can try to resolve this:

  1. Verify Relationship Settings: Double-check that the relationship is set correctly as many-to-one in the relationship editor.

  2. Refresh the Data Model: Sometimes, refreshing the data model can resolve visual inconsistencies. You can do this by clicking on the “Refresh” button in Power BI.

  3. Recreate the Relationship: Delete the existing relationship and recreate it. This can help reset any incorrect configurations.

  4. Update Power BI: Ensure that you are using the latest version of Power BI. Updates often include bug fixes that might resolve your issue.

  5. Check for Filters: Ensure that there are no filters or slicers affecting the visual representation of your data.

  6. Use Many-to-Many Temporarily: As you mentioned, setting the relationship to many-to-many and specifying the direction can be a temporary workaround. However, this might not be ideal for all scenarios.

If these steps don’t resolve the issue, it might be helpful to consult the Power BI documentation or reach out to Microsoft support for more detailed assistance.

danextian
Super User
Super User

Hi @GAN2 

 

It can be confusing but one to many or many to one are essentially the same and in a single direction relationship, the relationship always flows from the one to the many side.

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-relationships-understand 

 

Timesteps, being a dimension table, why would you want the fact table to filter it?

danextian_1-1732016487358.png

danextian_2-1732016653991.png

 

danextian_0-1732016075450.png

 










Did I answer your question? Mark my post as a solution!


Proud to be a Super User!









"Tell me and I’ll forget; show me and I may remember; involve me and I’ll understand."
Need Power BI consultation, get in touch with me on LinkedIn or hire me on UpWork.
Learn with me on YouTube @DAXJutsu or follow my page on Facebook @DAXJutsuPBI.

Thanks Danextian. I used the field timestep of that table to make some calculations and I thought that including it in the TsrResults, given the size of it, would be innefficient resourcewise, but I might be mistaken. Anyway, I might rethink the structure of the file

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! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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