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
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors