Forum Discussion

ysapiyev's avatar
ysapiyev
Responsive Resident
8 years ago

Data link doesn't work

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?

Need Help

4 Replies

Replies have been turned off for this discussion
  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    8 years ago

    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. :smileyhappy:

     

    Regards

    • ysapiyev's avatar
      ysapiyev
      Responsive Resident
      8 years ago

      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's avatar
        v-ljerr-msft
        Microsoft Employee
        8 years ago

        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. :smileyhappy:

         

        Regards