Forum Discussion

chuckie2706's avatar
chuckie2706
Regular Visitor
8 years ago

Xero data being allocated to incorrect months

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

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    chuckie2706,

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

    Regards,
    Lydia

    • chuckie2706's avatar
      chuckie2706
      Regular Visitor
      8 years ago

      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's avatar
        gb1
        New Member
        8 years ago

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