cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors