If you use Power BI and wish to use that to visualize Deskpro's data, you can configure Deskpro as a Power BI Data Source using the Deskpro API.

To connect to the API within Power BI to retrieve your data, follow the instructions below.

Configuring the API

1. Select Get Data from the Home ribbon, and select Web.

1. Select Advanced, then enter the URL for the endpoint you wish to pull.

   We recommend building the URL in individual parts, with the first part being your Helpdesk's URL, followed by api/v2/, then finally the endpoint you wish to query.

   Finally, add a HTTP request header parameter of Authorization with the value key {api_key}. If you need to generate an API key, you can do so from Admin > Apps & Integrations > API Keys.

1. Once that is added, Power BI will ask you how you want to authenticate.

   As you are already authenticating through the API key header in the previous step, select Anonymous, and apply it to the full URL.

Troubleshooting

If you are having issues connecting to the API, we first recommend double checking the endpoint URL is correct and that the API key is valid. If they are both valid, then it is likely due to Power BI's built-in authentication system. If you did not select the Anonymous option, it will attempt to authenticate using their built-in method first, and when it fails, it will not continue.

To fix this, you need to modify the saved credentials within Power BI to ensure it does not attempt to authenticate with any method other than the API key header.

1. Select File > Options and settings > Data source settings

1. Select the endpoint you wish to modify, then click Edit Settings

1. Click Edit under the credentials, and it should display the authentication screen from Step 3 of the setup process. Select Anonymous and save the changes.

1. Attempt to fetch data through the query again, and the API connection should be successful.