Xero To Power BI Connector
by Vidi Corp LTD
Xero To Power BI Connector
1. It is possible to combine data from multiple Xero companies together in a single dataset
2. Supports Direct Query
3. The data output of it can be customized for specific needs of a client
If you do decide to work with us to extract your data from Xero into Power BI, we will set our connector up for you. The process for setting it up is the following:
1. We would get access to your Xero and Azure. We would guide you how to raise access properly.
2. We would install our Python script that extracts data from Xero to Azure. Here is a demonstration of how this works.
3. We would schedule our script to run on a schedule. This would ensure that the data is refreshed automatically.
Once the data from Xero is extracted, you will be able to pull in inside of Power BI and build your reports.