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

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!

You can connect Intercom and Power Bi via Skyvia — the no-coding integration solution. This integration isn't performed directly — Skyvia provides it through a database or cloud data warehouse with automatic schema creation. Then you can connect Power BI to this database or data warehouse easily.