Xero connection not importing all data

[matd81]

Hi,

I've got an issue with Xero data.

Specifically, all data, except invoicelineitem is importing fine.

invoicelineitem data only imports for data in 2018, nothing prior.

Invoices exist in 2017, and I can use any data that isn't in the invoicelineitem table just fine. Any ideas why this field is limited to current year for import?

[v-yuezhe-msft]

@matd81,

Please open a support ticket on the support.powerbi.com site.

 
Regards,
Lydia

[matd81]

The below issue experienced by someone else posted on the Xero support page better explains the issue:

https://community.xero.com/business/discussion/41539562/

[matd81]

Hi,

I am using PowerBI Pro app linked to Xero.

I have all of my 2017 & 2018 data when I use a table visualisation.

I cannot for the life of me get any of the chart visualations to show any data prior to Jan 18, although I have data in the sytem I can see in a table view from Jan 17 right through.

No filters are current, and I've tried adding them to make sure it picks 2017 & 2018 data...

Any tips?