Microsoft Power BI Reporting - how to connect data using the API

Updated: 09/13/2022
Article #: 340


Cayzu allows you to extend your reporting capabilities by using our API to connect your helpdesk's data into Microsoft Power BI's visualization tool.

 

Let's use a real life scenario.  For example, let's say that you want to receive all resolved tickets for last 90 days and push that into Power BI:

 

You'd first use the following API call:

http://api.cayzu.com/api/Support_Ticket/ResolvedByAll?pageNumber=1&pageSize=10&daysFromNow=90&Token=YourToken

 

After receiving that data, you will need to push that into Power BI by following the next steps: 

 

1. In Power BI select Get data -> Web:

 

 

2. Select 'Basic' and in URL field enter API command

 

3. You will now see all data for the tickets:

 

 

 

4. Done

 

Want more information on Cayzu Help Desk? Visit www.cayzu.com

 

 







Rate this Topic:
Rating: 5.00 / Votes: 1