Relationships Not Working

[Shanebenedict]

I have a sales report and a stock report which i want to link with the product code which is the unique code in both sheets, however i am not able to create a relationship between the 2 files.

 

[wmh]

Did you get a resolution to the relationship issue?  I am having the exact same problem.

Thanks, Bill

[dedelman_clng]

PowerBI is usually pretty accurate when it comes to detecting non-unique values.  Check your source data.  Query Editor also has a "Remove Duplicate Rows" feature.

Hope this helps,

David

[Shanebenedict]

Dear David,

Thank you for your message however there are no duplicates nor blank spaces inbetween and hence I am trying to break my head with that.

[dedelman_clng]

Can you share anonymized data or the pbix file?

[Shanebenedict]

How do i share the pbix file 

[dedelman_clng]

Usually people put it on Dropbox, Google Drive, OneDrive or the like and put the link in a response.

[Shanebenedict]

https://drive.google.com/open?id=0B1oWGWTOQOaXcXNFMUJFb19FNGM