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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
akhaliq7
Post Prodigy
Post Prodigy

changing a 1:1 to a 1:*

I have two queries were I have a one to one relationship because in my second query my query folding breaks (due to a group by) and I don't want to do a left  join to my main fact table. So I am sticking with my one:one relationship but can someone explain in a table visualization when I was using columns from both tables the table visualization was kind of doing a full outer join so to fix this I manually changed the relationship to a many:1 and changed filter direction to single. Is this ok practice to follow or should it be avoided?

1 ACCEPTED SOLUTION
PaulDBrown
Community Champion
Community Champion

I manually change most of 1:1 to 1:* relationships (unless I'm certain 1:* won't happen in the future)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

4 REPLIES 4
PaulDBrown
Community Champion
Community Champion

I manually change most of 1:1 to 1:* relationships (unless I'm certain 1:* won't happen in the future)





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






thanks it's the first time I'm changing the relationships manually that's why was a bit nervous about break something. 

It won't break anything, but while you're at it, make sure the relationship is also set to single direction!





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






that's fine thanks for your help

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!

November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.