Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Solved! Go to Solution.
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
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
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.