Forum Discussion
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
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/
18 Replies
- Greg_Deckler
Community Champion
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/
- dkay84_PowerBI
Microsoft Employee
Instagram has an API but it doesn't look like there are endpoints available to view the data you are looking for:
- AnonymousNot 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
- sinanalmac
Resolver I
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- michaelbilling
Helper II
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
- v-huizhn-msft
Microsoft 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- AnonymousNot applicable
Yeah Angelia, I already did that. (y)
Thanks,
Thimma
- v-huizhn-msft
Microsoft Employee
Hi Anonymous,
Got it.
- annshmelRegular 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! - michaelbilling
Helper II
- Adel
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