Data Modeling Error

[Anonymous]

Hi,

I am building a relationship among several tables and some auxiliar ones. The auxiliar tables are Month, Companies and Operation.

• Month has the name of the month and the correspondent month number;
• Companies has the name of the company and the correspondent Company Code;
• Operation has the name of the operation and the correspondent Operation Code

I would like to creat a relationship to these tables and the auxiliar ones to access the information presented in the auxiliar ones. The month table is ok. However, I can't access the information in Operations and Companies. The relationship for these 2 are one -> several, for exemple:

Companies
Company Code - Company

1 - Name company Alfa;

2 - Name company Beta;

3 - Name company Gama
 
Table 1
Company code - column 1 - column 2 - column 3
1 - data - data - data - data;
1 - data - data - data - data;
1 - data - data - data - data;

Here are some printscreens. What am I doing wrong here? I thought this could be and easy fix, but I am really struggling in finding a solution. I thought I could easly access information from auxiliar tables by its codes.

 

 

 

[parry2k · Accepted solution]

@Anonymous very hard to tell what is going on. Can you share the pbix file? Remove sensitive information before sharing. 

[parry2k · Accepted solution]

@Anonymous Ah! I see you have to 1:1 relationship with month is causing this ambiguity. change that from many to one and it should work, even though fact tables have a single record for each month, force it to many to one with the month table and that should do it. T

[Anonymous]

It worked! Thank you so much!!

[parry2k · Accepted solution]

@Anonymous very hard to tell what is going on. Can you share the pbix file? Remove sensitive information before sharing. 

[Anonymous]

Sure, please find the pbix file.

I couldn't upload the file direclty. I am sharing a wetransfer link:

https://we.tl/t-aI0i0fknlD

[parry2k]

@Anonymous what does unico means when you are setting the relationship? Is it both or single?

[Anonymous]

Hi, sorry I am using a portuguese version. "Único" is like unique or single

[parry2k]

@Anonymous is there a relationship between companies and operation table? I cannot tell from the screenshot.

[Anonymous]

No, there isn't. Actually, these 2 tables I created inside Power Query. I wanted them to work just as auxiliar table for other to consulate to. There is no dependencies too:

[parry2k]

@Anonymous why your month table has relationship 1:1, isn't it suppose to be 1:*, 1 one on Month side

[Anonymous]

Hi friedn!

Actually, this is the only relationship that is working for all tables. The 1-to-1 make sense for Month, as all the ables have 12 lines (one for each month). The other ones (Companies and Operation) I can't create a relationship with the other tables.