Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents

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 sectioninside 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

Expand your data integration options - Explore our Power BI Connector for Jira

Gain a holistic view across functions and platforms while enjoying cost-effective solutions. Whether you’re using our Power BI Connector for Zendesk or considering combining Zendesk and Jira data for a cross-functional view, click to request a discount now ➡️

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.


If you need a detailed description of all fields and features of the Data Source page, please refer to this page.


If you need more information on how to create a data source, please refer to our step-by-step instruction.

Create data source.gif

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.


If you need more information on how to export data, please refer to our step-by-step guide.

Screenshot 2024-01-12 at 13.27.25.png


Learn about the difference between ServiceNow and Zendesk ⬇️