Data link doesn't work

[ysapiyev]

Hi everyone.

I was trying to link two data by date. In one field I have only two dates, in another 100. However, Power BI desktop says that one of the column should have unique values. What can be the problem?

[v-ljerr-msft]

Hi @ysapiyev,

As the error message indicated, both of the data fields should have duplicate values in your model, so they cannot be used to create relationship. Could you go to check if that is the case in your scenario?

If that is not the case, could you post your table structures with some sample/mock data which can help us reproduce the issue? It's better to share a dummy pbix file which can reproduce the issue. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. 

Regards

[ysapiyev]

@v-ljerr-msft

There are duplicate values, since they are item names. but have different values. Is there any ways to combine them?

[v-ljerr-msft]

Hi @ysapiyev,

Could post some sample/mock data and the expected result as I have mentioned above? So that I can further assist on this issue. 

Regards

[ysapiyev]

@v-ljerr-msft,

Here is data sample

http://www.filehosting.org/file/details/723525/wr.xlsx

http://www.filehosting.org/file/details/723526/wt.xlsx