Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.
------------------------------------------------
BI Blog: Datamarts | RLS/OLS | Dev Tools | Languages | Aggregations | XMLA/APIs | Field Parameters | Custom Visuals

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors