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
Anonymous
Not applicable

Instagram data in power bi

Hi,

 

Does Power BI has capability to extract Instagram data and can see organic and paid impressions? Any alternative apporach like facebook API.

 

Thanks,

Thimma

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

There is an Idea for this:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10986339-instagram

 

Otherwise, perhaps you can figure out a solution using OData or REST API?

https://www.instagram.com/developer/endpoints/

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

18 REPLIES 18
Adel
Helper III
Helper III

Hello, still no, but you can use windsor.ai they have a connector for instagram insights in power bi.
https://windsor.ai/connector/instagram/

But for instagram ads you can get it using the facebook ads connector, because now they are both connected with the meta ads manager

michaelbilling
Helper II
Helper II

You can find open source data connectors for Instagram and Facebook Ads/Pages here

There are prebuilt versions here

 

annshmel
Regular Visitor

You can use pre-built third-party integrations as an alternative solution to pull different Instagram data points in Power BI.

If you are using cloud data warehouse like Amazon Redshift or Google BigQuery to store your data, you can try Instagram Business IQ connector by Openbridge for collecting account and media data, and connect it to Power BI: https://openbridge.com/product/openbridge-instagram-business-iq.

The connector is free to use and gets you access to the following data:
- media metadata including account, media and user identification data and URLs
- media insights for video, photo, carousel album and stories include impressions, likes, reach, saved media, video views
- business account metadata including account ID, Facebook account ID biography, followers and follow counts, media count, name, profile picture URL, username and website
- business account insights including impressions, reach, gender and age distribution, location distribution, audience country distribution, audience city, online followers, followers count, email contacts, phone call clicks, text message clicks, get directions clicks, website clicks and profile views

If you are not using any data warehouse yet, Redshift and BigQuery offer free trials. You can sign up and connect either one to Power BI.

Be aware, with recent legacy Instagram API changes, you need to transfer to Instagram Business Account in order to get access to performance data.

Hope this helps!

v-huizhn-msft
Employee
Employee

Hi @Anonymous,

Please vote the idea as other persons above posted. For more details about Instagram API, you can connect them to get support.

Thanks,
Angelia

Anonymous
Not applicable

Yeah Angelia, I already did that. (y)

 

Thanks,

Thimma

Hi @Anonymous,

Got it.

Anonymous
Not applicable

Nope, generated API, but not working. did you get some time to look in?

 

Thanks,

Thimma

Hi @Anonymous,

What's your mean, your feature is unsupported until now. You vote the feature request, the product team will condider add it if more people vote it.

Thanks,
Angelia

Anonymous
Not applicable

using Instagram api its not working, I voted already..

 

Thanks,

Thimma

 

Anonymous
Not applicable

did you already make it work? are you using API for business account on Instagram? if yes, could you please share your code?

Hi @Anonymous,

Yeah, it's not working now. You vote it, just let PG know more people need the feature. So that it may be considered to develop, but not sure. It's up to PG's work. I really thank you for understanding.

Best Regards,
Angelia

 

Greg_Deckler
Super User
Super User

There is an Idea for this:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10986339-instagram

 

Otherwise, perhaps you can figure out a solution using OData or REST API?

https://www.instagram.com/developer/endpoints/

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

hi @Greg_Deckler,
thank you for your directions.
I read so many documents about that topic. but I couldn't establish a connection to Instagram via power BI
Is there someone that you know who has managed to connect to Instagram?

 

 

Best regards
Sinan 

Hi
You can build your in my open source Power BI connectors for instagram and facebook here
https://github.com/mbilling/pbiconnectors

Or download ready made versions here
https://www.scitylana.com/connectors

Michael

Hi @michaelbilling
 Thank you for  your solution .


This one only connects to Facebook.  I cannot be able to connect to Instagram. When I push the Instagram connector button it shows me facebook page for permission.

 

Do you know how to connect with this connector? Or  Did  you use  this connector  before  to connect Instagram

 

Best regards
Sinan

Instagram has an API but it doesn't look like there are endpoints available to view the data you are looking for:

 

https://www.instagram.com/developer/endpoints/

Anonymous
Not applicable

I logged in instagram and tried to create a access token for a product company, but it didn't generated Access token.

 

If I want to extract a product based company data like apple, samsung. will I be able to do that??

 

Thanks,

Thimma

I haven't worked with the Instagram API.  I suggest you look through their documentation.

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.