topic Re: Data link doesn't work in Developer

Data link doesn't work

ysapiyev — Tue, 30 Jan 2018 08:36:15 GMT

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?

Re: Data link doesn't work

v-ljerr-msft — Wed, 31 Jan 2018 06:35:47 GMT

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

Re: Data link doesn't work

ysapiyev — Wed, 31 Jan 2018 06:47:05 GMT

@v-ljerr-msft

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

Re: Data link doesn't work

v-ljerr-msft — Tue, 06 Feb 2018 09:47:34 GMT

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

Re: Data link doesn't work

ysapiyev — Tue, 06 Feb 2018 10:02:59 GMT

@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