cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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 4
Microsoft
Microsoft

Re: Xero data being allocated to incorrect months

@chuckie2706,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Xero data being allocated to incorrect months

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.

 

 

Snippet.JPG

 

Thanks,

 

Justin

Highlighted
New Member

Re: Xero data being allocated to incorrect months

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

Highlighted
Regular Visitor

Re: Xero data being allocated to incorrect months

At this stage, no.

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

 

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors
Top Kudoed Authors