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!
