SyncHub offers the ability to connect your Xero Payroll AU data to Power BI for advanced reporting. You can find instructions on how to get your **Database Credentials** [here](/connectors/xeropayrollau/knowledge-base/startreporting).
Once you have your credentials from SyncHub, please [visit our blog for a detailed walkthrough](https://blog.synchub.io/articles/how-to-query-your-xero-data-from-power-bi).
#### Troubleshooting
Have you tried [clearing your data source cache](/connectors/xeropayrollau/knowledge-base/clearwindowscache)?