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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Roodakker
Frequent Visitor

One of my dimension tables won't connect to the facts table - Relationship problem?

Hi, 

I have a table showing historical statuses made in a process. I've imported a staffing file to be able to filter out the cases handled by work titels. The oranged-out columns "E-mail" and "Status changed by" are both e-mail adresses that perfectly match so this is what I used for creating the relationship. One to Many - from Staffing table to Status history table. 

Somehow it won't work anyways. Can anyone please help me solve this? 

Roodakker_1-1706802442740.png

 

Roodakker_2-1706802706816.png

 

The other relationships going from Staffing is the same kind of relationship, but connecting to 4 different processes. 

 

Roodakker_3-1706802893141.png

Thank you for helping me out, 

 

Ronja

9 REPLIES 9
mlsx4
Super User
Super User

Hi @Roodakker 

 

Relationship seems to be properly done. Even cardinality.

Are you sure, your problem is not in some filtering in the report or the measures you may have defined?

Thank you for checking, so frustrating.. 

 

There is no filtering or measures used on either the visuals or page 😞 

And what fields are you trying to show or are you using?

Roodakker_0-1706804744942.png

 

Hi @Roodakker 

 

I have replicated your scenario and it is working perfectly.

mlsx4_0-1706807029585.pngmlsx4_1-1706807056492.png

mlsx4_2-1706807194478.png

 

 

I would suggest you to check in Power Query and trim both columns, be sure that both are same type (text) and even delete the relationship and create it again. As you can see it is working for me.

Thank you for testing a replicate of my issue. I tested all of your suggestions and even removed the query and added it again. Still won't work. 

As you say, it should work, but somehow it doesn't.. 


Have you tried to isolate the two tables? I mean, try them without any other relationship/filters, etc. And then add, step by step the other relationships. I don't really know what is happening, but I think the only way you'll find the problem is by leaving the basic and then try to reach what you have now. That is, a kind of "debugging"

Thank you for your suggestion! I have now isolated the problem, but still don't know why and how I can solve it. 

The dimensiontable works perfectly fine until I add my Calenderauto table and mark it as "Calender table". If I don't mark it as Calender table the relationships still work, but as soon as I mark it the connection breaks. 

Any ideas? 

Thanks! 

/Ronja 

Hey, I am currently having the same issue and i would like to know if you were able to resolve it? And if so, how did you go about it please?

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

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! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.