Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey There!
Is is possible to pull data from Facebook's Ad Services? Example running a campaign and being able to pull the data it's collecting on engagement?
Thanks
Derek
Hey, yes you could connect facebook ads to power bi using windsor.ai which will allow you to view data in real time.
Here the how to.
https://windsor.ai/how-to-connect-facebook-ads-to-power-bi/
Hi,
For pulling my data from Facebook Ads and visualize then in Power BI, I use the connector from Windsor.ai. There are templates, but you can also customize them and put any fields (metrics and conversions data) you need from the Facebook Ads data list.
I mostly use Power BI Desktop, but there is also an App source app. I also use this connector for my Excel reports.
@dkbollig @Anonymous @ranbeermakin @saisatya @stodds
I just released a new version of my open sourced Facebook Ads connector.
The new release includes support for scheduled refresh on powerbi.com
A ready-to-go connector is available for download on my sponsor Scitylana's website, https://www.scitylana.com/connectors
Link to Gihub is available here.
@michaelbilling
I have connected FB ads data successfully using your connector.
But PBI service powerbi.com could not refresh data.
Could you suggest any solution for this error.
Thank you
Error:
You can't schedule refresh for this dataset because the following data sources currently don't support refresh:
Query contains unknown function name: FacebookAds.Ads Unknown function name: FacebookAds.Ads is a valid Mashup library function name format. Hence fail the operation.
I've build a custom data connector for Facebook Ads
You can just copy the mez file from https://github.com/Hugoberry/FacebookAds/tree/master/build into your
[My Documents]\Microsoft Power BI Desktop\Custom Connectors directory
and enable custom connectors in Power BI.
The FacebookAds connector now supports two functions. The initial functionality FacebookAds.Campaigns() will return you the insights for your campaigns.
The Second function FacebookAds.API(uri,params) is more of a credentials wrapper for the enitre MarketingAPI. You can tailor your requests as you want with it.
Hi @hugoberry,
I installed your connector and works like a charm. Just wanted to ask how can I sign out or change facebook user. I tried by clearing permissions but still remembers the first user I entered so there's no way to sign in with another user. https://www.screencast.com/t/vjk7d7FYb
Is there any way to make a reset?
Thanks
Raul.
DataSource.Error: Web.Contents failed to get contents from 'https://graph.facebook.com/v2.11/act_71**9815*******/campaigns?access_token=******=name' (400): Bad Request
Details:
DataSourceKind=FacebookAds
DataSourcePath=FacebookAds
Url=https://graph.facebook.com/v2.11/act_71***99****/campaigns?access_token=********=name
Hi All,
You can go to my github page and download the Facebook Campaign Analytics PBI template. Open the template, add some inputs and your are done, you can analyze your Facebook campaigns, ad sets and ads easily through this template.
https://github.com/ranmax123/powerbi/tree/master/facebook%20marketing%20api%20power%20bi%20template
More in my blog post: https://bigintsolutions.com/2018/05/07/the-ultimate-power-bi-template-for-analyzing-your-facebook-ca...
If you have any questions, please open up an issue in github.
Thanks,
Ranbeer
Hey...I just tried using this and got this error (replaced token with xxxxxxx).
DataSource.Error: Web.Contents failed to get contents from 'https://graph.facebook.com/v2.11/act_59096518/campaigns?access_token=xxxxxxx&fields=name' (400): Bad Request
Details:
DataSourceKind=FacebookAds
DataSourcePath=FacebookAds
Url=https://graph.facebook.com/v2.11/act_59096518/campaigns?access_token=xxxxx&fields=name
Let me know if I'm missing something
@dkbollig you can check out in-built facebook connector to see if it does that. Also you can use APIs if you can find facebook APIs that returns data that you're after.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.