Forum Discussion
Connecting Hotjar with PowerBI as a data source
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)
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
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.
Pull data from a REST API Authentication
Regards,
Xiaoxin Sheng
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?
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)
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
I really wanted to use the web version but i just dont think i am advanced enough to do it.
