Cannot add the Xero app to connect data in Microsoft Power BI (either online or the desktop version)

[Anonymous]

Hi all,

Like many others it seems whenever I try and add the Xero app to my Power BI account it comes up with an error. After my IT team have tried for several hours; I contacted Xero and they told me to contact Microsoft. Helpful as ever....

Not sure why clearly so many people having this exact problem for what looks like several months and this hasn't been fixed as a matter of priority. 

Error message below:

• Activity ID74b85090-ae8e-4c43-8432-a80ef7714b4e
• Request ID7a865b7b-71e3-aceb-234c-16e1024955d4
• Correlation ID5f8fc463-4f26-76b3-f5b2-a6fc86a655be
• TimeTue Sep 01 2020 10:39:23 GMT+0100 (British Summer Time)
• Service version13.0.14205.60
• Client version2008.4.02508-train
• Cluster URI https://wabi-uk-south-b-primary-redirect.analysis.windows.net/

Please can someone advise.

[Aryna]

Hi, you can alternatively try to use Power BI connector for Xero. Here is the one of the providers: https://vidi-corp.com/connect-xero-to-power-bi-tableau-excel-looker-studio/ 

[Anonymous · Accepted solution]

HI @Anonymous,

According to your description, it seems more related to power bi Xero connector. I'd like to suggest you open a support ticket to report this or switch to using a web connector to get data from xero rest api to instead.

XeroConnect integration 

submit a support ticket

BTW, did other tools work well to connect Xero on your device? If all tools not works, please double check on your device firewall rules and network privacy setting to confirm if they block the request to connect to Xero data source.

Regards,

Xiaoxin Sheng