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?
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...
The below issue experienced by someone else posted on the Xero support page better explains the issue:
@matd81,Please open a support ticket on the support.powerbi.com site. Regards,Lydia
Power BI Super User, Greg Deckler, explains
Register by September 5 to save $200
Engage and empower students with Power BI!
Continue your learning in our online communities.