SyncHub offers the ability to connect your Xero Payroll UK data to Power BI for advanced reporting. You can find instructions on how to get your **Database Credentials** [here](/connectors/xeropayrolluk/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/xeropayrolluk/knowledge-base/clearwindowscache)?