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
mickjaeger
Frequent Visitor

Data Model Relationship Connector Visual (What does it mean?)

Hi PBI Crew!

I recently started seeing a new and unexpected model connector visual. I searched online forums, release notes and MS Learn but I can't find anything that identifies why the data connector looks different.

 

Here's a snippet from my data model. Anyone know why the connector line ends with these <> connector brackets? 

It is correctly identified as a 1:many relationship.

mickjaeger_0-1675976574895.png

I will add that the table on the top and lower right are part of a Power BI online dataset (which is a direct query connection to the model). The table on the lower left is an imported table from our data warehouse. The relationship in question are two dates, date from the source transaction table to the date dimension (both are date format in the source tables).

 

The data is not filtering correctly in my report even though it looks to be connected properly. I can't get over the fact that the data connector visual is noticably different. Maybe I'm using the wrong words in my search but it's also weird that I can't find this documented anywhere. 😕

 

Any ideas?

 

Thanks in advance!!

Mick

1 ACCEPTED SOLUTION
vicky_
Super User
Super User

I did some googling and found this thread: https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer
TLDR, Greg Deckler says: "the two tables have different storage models."

View solution in original post

2 REPLIES 2
vicky_
Super User
Super User

I did some googling and found this thread: https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer
TLDR, Greg Deckler says: "the two tables have different storage models."

Hi Vicky,

Thanks for the response!!! That link didn't take me to a specific post so I wasn't able to read that content you found (although I'd love to!). 

Different storage models ... interesting, maybe that's the direct query vs. import? 

Thanks again for the assist. 

Mick

PS - I was able to get my dates to filter correctly. I opened Power Query and realized the transaction table had the dates set as date/time. I converted that to date and it's much better now! 😉

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!

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.