The Invantive drivers make all somewhat usable tables available for Freshdesk in real-time.
The Freshdesk tables are available for use in SQL, Power BI Desktop, Power BI Service, Power Query, Azure Data Factory, Qlik, Tableau and other popular packages.
The steps to link Freshdesk with Power BI can be found in Connect Power BI to Freshdesk, 180 days free.
A few Freshdesk tables were the most used over the past year. The table below shows which Freshdesk tables are the most popular and will help you selecting tables.
| Position | Table name | Description |
|---|---|---|
| 1 | tickets | Tickets |
| 2 | ticket_tags | Ticket tags |
| 3 | contacts | Contact persons |
| 4 | ticket_conversations | Ticket conversations |
| 5 | agents | Service desk agents |
| 6 | companies | Customers |
| 7 | recent_tickets | Recently created tickets |
| 8 | time_entries | Timesheets |
| 9 | survey_satisfaction_ratings | Survey satisfaction ratings |
| 10 | ticket_attachments | Ticket attachments |