Power BI by Microsoft is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into interactive insights. Using the Power BI Connector by Zendesk allows you to import your Zendesk data to Power BI.
This article covers the following topics:
- Overview of the Power BI Connector by Zendesk
- Signing in
- Using the Power Query M language to query data
Related articles:
Overview of the Power BI Connector by Zendesk
The existing Zendesk Power BI connector by Microsoft has a known issue where it can’t retrieve records for more than 1000 rows. For example, if an account has more than 1000 tickets, it returns the following 422 error:
Zendesk has developed a new Power BI connector that solves this issue and is currently in beta. The new connector uses Cursor Based Pagination (CBP) to retrieve data from the Zendesk API.
The new connector is named Zendesk Data (Beta). It will eventually replace the legacy connector, which is named Zendesk (Beta Legacy).
Signing in
The sign in experience is the same as the legacy connector.
After you sign in, you’ll see all existing endpoints are available in the new connector.
Using the Power Query M language to query data
If you are using the Power Query M language to query data, there’s a slight difference in the beginning part of the query. The legacy connector uses Zendesk.Tables() to initialize the Source:
let
Source = Zendesk.Tables("https://yoursubdomain.zendesk.com"),
views = Source{[Key="tickets"]}[Data]
in
views
The new connector uses ZendeskData.Contents() to initialize the Source:
let
Source = ZendeskData.Contents("https://yoursubdomain.zendesk.com", []),
Users = Source{[Name="Users"]}[Data]
in
Users
If you have existing queries using the legacy connector, change the Source initialization part and the rest of the code will work properly.
If you are using the Power BI connector in any other way, please contact Zendesk Customer Support, and we will provide a migration path.