cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tobben1986
New Member

Load data from Intercom.io

Hi,

 

Does anyone have any experience with loading data from Intercom.io through Power BI?

 

I have tried to connect to Intercom with both Web and Odata-feed without any success.

 

For instance I have typed the following url: https://api.intercom.io/counts?type=user&count=segment 

The acccess window appears and I have tried all the different access options (Anonoumus, Windows, Standard, API-adress and Organization-account). I have an Intercom account and I have obtained the API- ID and API-Key, but I keep getting the error message "Provided ID is invalid".

 

Any feedback would be greatly appreciated! Many thanks.

 

B.r. Simen

10 REPLIES 10
Harry33
Helper I
Helper I

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.

nisahu
New Member

Hi 

 

Someone knows something else to connect Power BI with intercom ??

 

Thanks

ccpereirabt
Regular Visitor

Hi guys! Can anyone help me out? Trying to connect Intercom with Power BI but with no luck. 😞

bobintercom
New Member

Hi,

 

The Basic auth credentials you need should be here: https://app.intercom.io/a/apps/_/integrations/api-keys <- your App ID and API Key are the username/password. Could you show a screenshot of your error?

 

Bob (bob@intercom.io)

Hi Bob, I have got a personal token and tried to connect to Intercom via a web URL but without success. What is the best way to load Intercom data to Power BI?

 

Thank you in advance.

Luzern

Did you ever manage to connect Power BI to the Intercom API?

Hi,

I managed and can help if needed.

Unfortunately refreshes are only available through publishing via the Desktop application because the service won't be able to refresh it directly as of now. Hopefully the are going to improve this in the future. 

Regards,

Mauro

I'd love to know how to do this with an access token now that API keys are being deprecated by Intercom.

------------------------------------------------
1. How to get your question answered quickly - good questions get good answers!
2. Learning how to fish > being spoon-fed without active thinking.
3. Please accept as a solution posts that resolve your questions.
------------------------------------------------
More tips and guidance in my Power BI architecture and development blog

Hi Mauro,

How have you done it?
Do you have an example code that I could use in PBI desktop?

Best,
Björn

Anybody got it to work?

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Solution Authors