Web Fresh Report is an API Freshservice connector TM allowing data access for PowerBI, Excel and other ODATA consumers.
Please follow the instructions below:
Register new user. The credentials will be later needed to retrieve data
After registration navigate to the Service tab and enter Freshervice URL and Api Key.
To get your API key:
Then launch refresh data. If connection is successful 90 recently updated tickets will be retrieved.
Open Power BI desktop. To connect to an OData feed, select Get Data > OData Feed from the Home ribbon in Power BI Desktop.
In the OData Feed window that appears, type or paste URL https://webfreshreport.azurewebsites.net:443/odata feed URL into the box, and select OK.
Choose basic authorization and enter credentials used during the registration process.
Power BI Desktop connects to the OData feed, and displays the available tables. Tables TicketsV2 and StatsV2 may be empty if your system does not support V2 interface. The Navigator window shows a preview of the currently selected table.
Select the Load button, and import all of the data tables elements selected in the left pane. When we select Load, Power BI Desktop imports the selected items, and displays a Load window of the import progress. The version will retrieve 90 recently modified tickets.
Please navigate to Offer to find out more.
If you have any problem with using the service please contact us. We will be more that happy to help.