Connecting HotH to PowerBI using QuickReports

Documentation

Thank you for your enquiry into PowerBI connectivity with HotH! It is possible to connect HotH with PowerBI through QuickReports.

HotH has an https API to run QuickReports remotely and get data in JSON format.

This product doc explains how to run a named report via an HTTPS request and returns the report output in a structured JSON format:

https://houseonthehill.com/docs/https-report-api/

Within PowerBI if you choose a Data Source of ‘Web’ and then input the https API:

This will bring back data in JSON:

You can then drill down into each record:

This is a lot of information to try and grapple with connecting PowerBI to HotH so if you need any further help let us know!

Maximize Your Organisation’s Impact

HOTH is committed to helping charities and non-profits achieve more with less by providing a powerful platform for IT and compliance management.

Making service simple—smarter, faster, together.
Hoth empowers teams to deliver smarter services across IT, Customer Support, Facilities, Governance, and Enterprise Management. Our flexible, AI-supported platform streamlines operations, boosts collaboration, and ensures compliance—making it easy to support your people, processes, and priorities.