cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nike619 Visitor
Visitor

Desktop Vs Desktop for RS. - Relationships with duplicates

Hello!

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.


1 REPLY 1
saykasku Regular Visitor
Regular Visitor

Re: Desktop Vs Desktop for RS. - Relationships with duplicates

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

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 62 members 996 guests
Please welcome our newest community members: