1. First you need the API URL. Go to Reporting > Analytics to obtain the URL for the content you want to report on.

2. Next go to Settings > Data Export. There are many Freshservice areas that can be queried, such as Changes, Tasks, Releases, Assets, etc, but we are often most concerned with Ticket data. Hover your mouse over the API link in the Total Tickets row and a URL will pop-up. Click the copy icon on the end and you now have the Ticket data API URL in your clipboard.

3. In your Power BI report you will want to create a report that connects to a basic Web source. Drop the API URL you copied into the source settings and click Next.

4. You will need credentials to connect to the API. For Freshservice data this cannot be done through Windows, SSO, or M365 credentials. It must be done using your own Freshservice API key. To get this, go back to Freshservice and go to your user profile settings. Your API key should appear in the top-right corner of your profile. Highlight and copy the API key text.

5. Go back to the credentials portion of your Power BI report and paste your API key into the User Name field with a blank password. This should allow you to query the Freshservice source.

6. When you add the API as a source into Power BI it will look like this at first. Right-click on the kemin.freshservice.com icon and select CSV to convert the source into a usable query.