Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error while Refreshing data on power bi Desktop

Hello,

 

I have a PowerBi desktop file connected to SQL Server (import data model)

 

its working fine for few months now.

 

today i tried to refersh the data and it says there's a duplicate in one of the TrxID entries (TrxID values should be unique since they are the primary key) i discussed this with the developer and he assured me the error and fixed it in the DB.

 

but again if i try to refersh it says the TrxID column has duplicates. 

here is a screen shot..

 

ERROR

 

what should i do?

 

appreciate your help

Need Help

11 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      thank you for your reply. but your suggestion is not working. there is no duplicate in the db im 100% sure, niether its in the data model. delete duplicates wont work. 

       

      any other suggestions?

       

      NB: data updates daily in the server, and i have to refresh it in the powerbi model.

      • mahoneypat's avatar
        mahoneypat
        Microsoft Employee
        6 years ago

        Check for blank or null values too.  In Data View, when you highlight that column, does the # of distinct values equal the number of rows?  That's where I start when troubleshooting duplicates on key columns.  If needed, you can make a table visual with the values from the column and a measure that counts the rows and look for which one is >1.

         

        If this works for you, please mark it as solution.  Kudos are appreciated too.  Please let me know if not.

        Regards,

        Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    UPDATE:

     

    if I refresh data i get 7 duplicate values in the transactions. i have the duplicate values in my data model, not in the data base. i just confirmed that. 

     

    Now im getting crazy. why are there duplicates in my data model though the source dont have duplicates. ?

     

    here is a screenshot from my db. as you notice the entries only appear once.

     

    SC from DB

     

    and here is my power bi report showing duplicates after the update. 

     

    i suspected this is because of cached data, i cleared cache from <Options> but did not work. 

     

    I appreciate you support gentelmen. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

      Please refer this documentation to remove permission of SQL server data source and reconnect it. Later check if the issue still persist...

      Best Regards

      Rena

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hello Anonymous 

        Thank you for your responce.

         

        the link to document is broken.

         

        I have an update here:

         

        i found a value that powerbi is considering as duplicate here is the image from my db:

         

        the 00 in the starting of the TrxID is considered duplicate in powerbi

         

        there are 7 values considered duplicates as per power bi that start with 00

         

        NOTE: in powerbi the data type of TrxID is TEXT

         



        what can i do about them?