Xero - beautiful accounting software

Xero Business Community

Xero Business Community

Hi everyone, Come on over to the new discussions in Xero Central. It’s a more intuitive way to connect and chat all things business with one another. Ask questions, dish out answers, and get involved.

You can still view topics in the Xero Business Community to see all the useful knowledge that’s been shared there; and you can restart conversations you feel have been of huge value to you on Xero Central.

If you have brilliant ideas for innovations, you can keep on adding feature requests in the Xero Business Community, and voting on existing requests. There’s more in store, as we come up with the best way to take on your thoughts and share developments
Community > Using Xero Connected Apps >

PowerBI Connector - Not Bringing Across Line Items in Full?

Started by Glenn Richmond -   in Using Xero Connected Apps

Hi guys,

We've been doing some work with the PowerBI connector for Xero and in theory, it's great. However, when trying to use it in practice, we noticed that it doesn't seem to bring across all Invoice line items. We noticed this because when we created our KPI dashboards, the numbers didn't add up. The data seems to go back for 3 months, but beyond that, we have no line item data.

Has anyone else had success with the PowerBI connector or is there a support avenue that we can go down for this?
Same problem - the invoices table is complete, but the invoice lines only has a small subset of the true data.

Reuben O'Callaghan  

Any solution to this?
Mine imports all data for 2018, leaving all invoice line items from before then empty.....

Mat Detlefsen  

Hi everyone, appreciate looking for answers from your peers here. However, this does sound like something the Support team at Microsoft Power BI would want to have a closer look into.
They built the integration between themselves and Xero, and are best placed to explain the syncing of data through this integration. Keen to hear how you get along, and feel free to share for everyone here :)

Kelly M (Community Manager)  

You can't get support from MSFT unless you purchase Power BI. I also notice that InvoiceNumber is missing from the InvoiceLineItem table ... that diminishes usefulness.

Stephen Sweeney