Xero data being allocated to incorrect months

[chuckie2706]

Hi All,

New user to Power BI but loving what it could be achieved with it.

I've integrated a number of Xero files however all seem to have the same issue, data pertaining from July to December 2017 is coming up on Power BI as being July To December 2018 which throws almost every report out.

I asked Xero whether there was anything on their end that caused this, however they've directed me back to Microsoft.

Any ideas would be most appreciated.

Justin

[Anonymous]

@chuckie2706,

Could you please post the screenshots about data in Xero and Power BI Service?

Regards,
Lydia

[chuckie2706]

Hi Lydia,

Of course.

The attached snippet shows the data from July 2017 to December 2017 is missing and has instead been included as July 2018 to December 2018.

All I've done with this is follow the Xero add-in steps that import the data. No changes have been made anywhere in Power BI.

Thanks,

Justin

[gb1]

We have a simillar problem - did you find the fix?

[chuckie2706]

At this stage, no.

Microsoft have sent me courtesy emails weekly to advise their teams are still looking into it.