Showing results for 
Search instead for 
Did you mean: 
Not applicable

Desktop Vs Desktop for RS. - Relationships with duplicates


I have a general question regarding the differences between PBI Desktop and PBI Desktop Optimized for Report Server. 

I have multiple SQL queries setup and succesfully pulling data ( Around 1.6 Million rows total ) 

I have a sufficent date table, a sales data table containing product lines and catalog numbers and a product table that contains matching catalog numbers, mfg discounts, internal cost etc. 

In PBI Desktop I was able to create a many-to-many relationship between catalog numbers with no errors pertaining to "Can´t create a relationship between two columns because one of the columns must have unique value"  I was able to create the report I needed and verified it with some other reports I have built through Tableau.

However, with Power BI Desktop / RS I keep receiving the following error "Can´t create a relationship between two columns because one of the columns must have unique value" - Is this something that is planning to be updated when PBI/RS is updated next? It's the exact same queries and data for both programs but report server is unable to link the data in the way that it needs to be linked.

Resolver I
Resolver I

Tried creting all type of relations here?
Same data in both cases for sure?


There is no official differences between this two versions of PBI Desktop in relationships area.

Helpful resources

Power BI Show Ep 4 Post Show Carousel.jpg

The Power BI Community Show

Shabnam Watson demos Incremental refresh & Hybrid Tables and Leila Etaati demos Charticulator.

PBI April Release 2022 768x460.png

Check it out!

Click here to read more about the April 2022 updates!

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!