I have an issue with Power BI and Xero. I have asked Xero for Support but their response was to contact you for assistance.
See below email chain with Xero.
Thanks for providing the link. It looks like the issue is on Power BI's end and you'll need to contact them for more information regarding this as the integration between Xero and Power BI has been designed by them.
Could you let me know what needs to be done to correct this?
I have been playing around with Power BI and Xero connection. I noticed there is an odd thing in the Monthly Profit and Loss graph.
The dates are not being sorted in chronological order. It seems to be sorting the month first than financial year. So April FY2018 is April 2018 and Dec FY2018 is Dec 2017.
It seems I cannot change this, and have a feeling that somehow Power BI is thinking the financial year is Jan-Dec, but in Xero (AU) the financial year is Jul-Jun and it seems the system is not picking up the conversion properly.
Do you know where I can get assistance with this?
Cannot really use Power BI if I cannot resolve this issue as it really distorts the graphs.