Document toolboxDocument toolbox

User Guide

How to Export Data from Zendesk to Microsoft Power BI


It’s important to understand that Power BI Connector is initially installed on the Zendesk Support platform. To export data from the Zendesk SELL platform, please read this guide.


1. Create Access Token


An access token is a security credential used in web applications to authorize and authenticate a user or application’s access to specific resources or data.

We will use an access token as a password for Microsoft Power BI to securely transfer data.

You can create your token by accessing Zendesk API section inside your Zendesk Support instance.

If you need more information on how to create an access token, please refer to our step-by-step instruction.

Zendesk Administrator role is required for this step. If you don’t have such a role, please contact your Zendesk Administrator to grant you the corresponding permission.



Zendesk API.gif


2. Create Data Source


Now you need to create a data source for data you want to export from your Zendesk to your Microsoft Power BI. You can do it by accessing the Connectors page inside the Power BI Connector for Zendesk.

You have to name your data source, adjust sharing settings, and filter the tables you’d like to be in your data source.


3. Export Data into Microsoft Power BI


After creating an access token and creating a data source, you can easily export your data into Microsoft Power BI. Being on the Connectors page, select Copy link. Launch your Microsoft Power BI, authorize, connect, and start working with your data.