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
Highlighted
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
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

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

Upcoming Events

Upcoming Events

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

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors