Connecting Hotjar with PowerBI as a data source

[Shahodo]

I am looking for a way to connect Hotjar to PowerBI where if I get a new answer to a survey it will update the dashboard automatically, is there anyway to actually do this? via an API or any other method?

[mfinlay]

FYI this is still an issue in 2022. I've been repeatedly trying to automate an extract from HotJar, but they only offer Zapier as an integration option. This is effectively chargable per survey/recording, so gets expensive very quickly.

We did also write our own screen-scraper to login and download the csv, but the website wasn't stable enough to use this.

thanks

Matt

[julienvdc]

Hey @Shahodo I am also looking for this setup... Have you managed to achieve what you were looking for in the end? Would you mind sharing your work?

[Anonymous]

Hi @Shahodo,

Yes, you can consider using web connector with corresponding rest API to get data. After you publish to power bi service and verify its data credentials, it will refresh automatically.

Hotjar API 

Pull data from a REST API Authentication 

Data refresh in Power BI 

Regards,

Xiaoxin Sheng

[Shahodo]

Hi @Anonymous ,

I appreciate your help! However, Hotjar's API doesn't allow data extraction and is used only to send user attributes. If you tried this method; did it work? 

Any other solutions? 

[Anonymous · Accepted solution]

HI @Shahodo,

After I double-check on hotjar documents I found it only shares the user attributes related APIs for development. (the official document methods they provide 'share' and 'export' features to sharing or getting records)

How to Share and Export Data 

So if you want to get data from this service, you can export and get data from that file to power bi(simple way). In addition, you can try to use programming languages to simulation 'sign in' and using the export feature to get the respond CSV/xlsx files and package them as an interface or web service. (the hard way)
Then you can simply use power bi web connector to get data from that interface/web service.

Regards,

Xiaoxin Sheng

[gingerclaire]

I really wanted to use the web version but i just dont think i am advanced enough to do it.