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 b...
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 

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.