Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.