Forum Discussion

douglasbratten's avatar
douglasbratten
Frequent Visitor
10 years ago

xero currency conversion

I have installed the Xero connector and my data has been loaded. On review of the reports I notice that the liabilities are all in local currencies rather than translated into the base currency, and thus the reports are wildly incorrect.

Can anyone update the connector or tell me a workaround please.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    Hi douglasbratten,

    Do you load data from Xero into Power BI Service using Xero content pack? If that is the case, you are not able to implement currency conversion.    

    A possible method is to connect to Xero from Power BI Desktop, import an extra currency conversion table, then write DAX formula to convert conversion for the related columns in your data source, there is a similar thread for your reference.

    However, it seems that we are not able to get Xero data into Power BI desktop. Regarding to this issue that connect to Xero from Desktop and update Xero content pack, please vote it and add comments in the following idea.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/7141465-connect-to-www-xero-com

    Thanks,
    Lydia Zhang