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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
nicolast29
Helper V
Helper V

Why does it detect a many to many

Hi

I have a table DIM_Salaries from wich a delete duplicate (verify under Excel)

I link it to a fact table FTS_Heures, but it doesnt want a one to many ...... 

nicolast29_0-1691573781994.png

 

here my file

https://1drv.ms/u/s!AoqtZHsX4BzvhL4Cmhkus3rE_JjUIg?e=c8J7nc

 

 

1 ACCEPTED SOLUTION
eliasayyy
Super User
Super User

hello based on what you sent , it seems you have duplicates therefore , a many to many relationship , but it seems you have a duplicate in your dim salary table 

annonymous1999_0-1691574765143.png


so maybe just remove duplicates or create a new table 

Values = VALUES(dim_salaries[id])


here is your duplicate 

annonymous1999_0-1691574895216.png

 

View solution in original post

4 REPLIES 4
nicolast29
Helper V
Helper V

hi

thanks to your screenshot

i found the error

a space in one of the case

have a nice day

nicolast29
Helper V
Helper V

Hi thanks

But in the Power Query transformation i have remove duplicate 

That is why i don't understand

nicolast29_0-1691575002941.png

 

Thats weird did you select all columns and pressed remove duplicates? Maybe you have the same id but it has different dimensions in the column 

eliasayyy
Super User
Super User

hello based on what you sent , it seems you have duplicates therefore , a many to many relationship , but it seems you have a duplicate in your dim salary table 

annonymous1999_0-1691574765143.png


so maybe just remove duplicates or create a new table 

Values = VALUES(dim_salaries[id])


here is your duplicate 

annonymous1999_0-1691574895216.png

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors