Forum Discussion

tcocaro's avatar
tcocaro
Regular Visitor
8 years ago
Solved

We couldn't install Xero

I get the following issue when i try to connect XERO to POWER BI for the first time, I have tried using EDGE\CHROME and the same error. The error seems to point to a random line item transaction (a brush purchase) but cannot explain how POWER BI treats this as a duplicate and XERO doesnt . It seems to imply the XERO data is corrupted but surely not? - anyone else face this issue would love to hear from you.
 
Data source errorColumn 'Code' in Table 'Items' contains a duplicate value '1662336' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: Items.
Activity ID19653696-ff0c-48f3-9471-886edc6e834c
Correlation IDc6850b9b-2fcf-899c-bdd4-a195b8a2b04d
Request ID5927ad9b-d5f6-f2a4-0311-8a999bf813f9
Status code400
TimeTue May 08 2018 09:48:31 GMT+1000 (AUS Eastern Standard Time)
Version13.0.5172.221
Cluster URIhttps://wabi-australia-southeast-redirect.analysis.windows.net
Custom Visuals
Dashboards
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    8 years ago

    Hi tcocaro,

     

    As the error message mentioned, there is a duplicate value '1662336' in column "Code" of table "Items". I would suggest you go to the Xero side, after ensure the column "Code" values are distinct then import Xero content pack again in Power BI.

     

    Best Regards,
    Qiuyun Yu 

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    Hi tcocaro,

     

    As the error message mentioned, there is a duplicate value '1662336' in column "Code" of table "Items". I would suggest you go to the Xero side, after ensure the column "Code" values are distinct then import Xero content pack again in Power BI.

     

    Best Regards,
    Qiuyun Yu 

    • tcocaro's avatar
      tcocaro
      Regular Visitor
      8 years ago

      Thanks for the reply v-qiuyu-msft, I think my issue was that I assumed that Xero wouldnt allow for its own data to be corruped and instead assumed that the issue resided with the integration between POWER BI and XERO. I then looked more closely into Xero and realised it allows for duplicate Inventory items using the same CODE????, I deleted the one offending item (a Paint Brush) of all things and then everything worked fine.

       

      Thanks for your reply, this issue is now resolved.