Dear friends,
Do you guys know how can I connect my Intercom data into my MS Powerbi? I've searched and it looks like it is possible to get this done using the rest APIs provided by the Intercom but I'm not managing to access them, can someone help me on this?
Kind regards,
Best answer by Milan
View original
+5
In order to use API, you need proper authentication, with the access token.
You have all the details here: https://developers.intercom.com/building-apps/docs/authentication-types
Hello @rodrigo m12 👋,
Can you share a bit more information? Which metrics are you want to track via PowerBI?
Hello @roy s11 , I'd like to collect the conversations details (responses, first answer time, tags, etc). I know I can check all these info at the reports section, but I'd like to bring these info and connect with other data sources (like my CRM, for example) to create richer dashboards.
I just do not know exactly how I make the proper authentication.
I created an app on my Dev Hub called PowerBI:
And when I access it, I have the following information:
My access token, and also my CLIENT ID, CLIENT SECRET.:
To connect to PowerBI, I'm trying to insert the rest APIs urls in the Web Data Source, on the app:
(I don't know exactly what should I insert here)
And I also don't know how can I access the web content:
Should I do it anonymously? Should I insert basic credentials (my email/password from intercom or my CLIENT ID / CLIENT SECRET)?
I'm getting stucked in this part.
Any help is much appreciated.
Thank you very much!
Hi @rodrigo m12
We found a solution about it.
1- You should decide which modules you'll use. You can check > https://developers.intercom.com/intercom-api-reference/reference#introduction/p>
2- Then you need to proper your autentication as everyone said. You can do it from intercom developer hub. About your choices you can do it
Powerbi is supporting connection via API's. But you can't roam pages. On this time, you can use google sheets.
3- On google sheet you should use api connector. https://workspace.google.com/marketplace/app/api_connector/95804724197you can use this. With this add-on you can roam pages and set the data.
4- When you get your raw data on google sheet you can connect powerbi with that sheet. You can edit everything after it. On powerbi you'll need that, unixtimestamp to datetime. On pbi you can do it with
#datetime(1970, 1, 1, 0, 0, 0) + #duration(0, 0, 0, [UnixTime]/1000)it.
5- And also you can watch this for unixtime to datetime. https://www.youtube.com/watch?v=3N27eS2oJmA it's Spanish but understable.
We just found the solution and we start to track everything from powerBI. If you have a question feel free to ask.
Have a nice day.
Thank you!
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.