Bridging table many to many

[DrHematite]

Hi everyone,

I'm trying to create a bridging table between two larger tables.

To do this, I have duplicated one of the queries, removed all the columns I don't want, removed duplicates in the relevant column, removed errors (though none were found), sorted alphabetically, and removed the null row at the top in the query editor.
However, when I try to relate the tables, Power BI won't allow me to create a 1:* relationship with either of the two tables. Only *:* is possible. I don't understand why

I've checked in excel with exported data and no duplicates exist.

Appreciate any help.

Thank you.

[v-yuta-msft · Accepted solution]

@DrHematite ,

This means the one side table have duplicate values, please check it. You can also click remove duplucate values in query editor and check if this issue persists.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[venal]

@DrHematite 

Can you please PBIX file with the sample data to re-pro the issue.