Using Power Query M with Zendesk Power BI Connector
How do I use Power Query M language with the new Zendesk Power BI Connector?
To use Power Query M language with the new Zendesk Power BI Connector, you need to adjust the initialization of the Source. The new connector usesZendeskData.Contents()instead ofZendesk.Tables().
For example, the new query initialization would look like this:
let Source = ZendeskData.Contents("https://yoursubdomain.zendesk.com", []), Users = Source{[Name="Users"]}[Data] in UsersThis change is necessary to ensure your queries work properly with the new connector. If you have existing queries, simply update the Source initialization part.
More related questions
What is the Power BI Connector by Zendesk and how does it work?
The Power BI Connector by Zendesk allows you to import your Zendesk data into Power BI for interactive insights. It is a tool that helps you turn your unrelated sources of data into meaningful visualizations and reports. The new Zendesk Data (Beta)…
How do I sign in to the new Zendesk Power BI Connector?
Signing in to the new Zendesk Power BI Connector is the same as the legacy connector. Once signed in, you will have access to all existing endpoints available in the new connector. This seamless sign-in process ensures that you can easily…
Why can't I see the new Zendesk Power BI Connector in Power BI Desktop?
If you can't see the new Zendesk Power BI Connector in Power BI Desktop, it might be because it was included in Microsoft's April release. Ensure you have downloaded the latest Power BI Desktop version from Microsoft, specifically the April 2024…
How can I limit the data imported by the Zendesk Power BI Connector?
To limit the data imported by the Zendesk Power BI Connector, you can use the Power Query M language to specify the data range or criteria you need. For instance, if you want to import only the last 7 days of tickets, you can adjust your query to…
Why is the Zendesk Power BI Connector not retrieving all my tickets?
The Zendesk Power BI Connector might not retrieve all your tickets because it uses the tickets API, which doesn't include archived tickets. This means the number of tickets you see in Power BI might be less than the total count from the Zendesk…
How do I handle authentication issues with the Zendesk Power BI Connector?
If you encounter authentication issues with the Zendesk Power BI Connector, especially when publishing to the Power BI service, it might be due to OAuth token errors. Ensure that your credentials are updated manually and retry the connection. If…
Why can't I find brand-related information in Power BI from Zendesk?
If you can't find brand-related information in Power BI from Zendesk, ensure you are looking for thebrand_idfield, which indicates the brand associated with a ticket. If thebrand_idis not visible, double-check your data set and query…
Interested indeflectingover 70% of your Zendesk support tickets?
Zendesk Support Tickets
Zendesk Messaging (live chat)
Join1,000+ companies reducing their support costs and freeing up support agents for more important work
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
“We needed an AI agent integrated within our current tools. My AskAI was the only solution that wasn't going to disrupt our operations.”
Zeffy
“At the end of last year I was given the challenge - how can we provide the same or better service, without hiring anyone?”
Zinc
“My AskAI blew everybody else out of the water. It made the selection process very easy for us.”
Customer.io($50M+ ARR)
“It now resolves 71% of queries (over 35,000 every month), meaning more time solving complex issues and improving UX.”
Freecash
Reduce support costs.Spend more time on customer success.
