Facebook Analytics (connector)

[pawelj795]

Hi,
I found at another topic that the Facebook connector is gone for real since April 2020.
https://community.powerbi.com/t5/Desktop/Facebook-Data-Connector/td-p/921623

Is there any way to connect my Facebook page data?

[QueryWhiz]

Hi @pawelj795 I know this reply is very late. Since there’s no built-in connector for Facebook Ads to PBI, you will have to look for another way. As a workaround, maybe you can use a 3rd party connector, it can save you a lot of time compared to the other options. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Facebook Ads connector in the data sources list:

After that, just grant access to your Facebook Ads account using your credentials, then on preview and destination page you will see a preview of your FB fields:

There just select the fields you need. Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[mrnelsch]

I wrote this blog on my website that is very helpful to answer this question!

This blog explains all the ways of how Facebook data can be connected to Power BI:

Link to blog about connecting Facebook to Power BI  

(It's in dutch, so you might need to use Google Translate)

[Djordje_M]

Fb Connector is gone, but there are services like Windsor.ai to offer to collect and organize your data from various marketing platforms like Facebook Ads and Google Ads, Linked In Twitter, and CRM software like HubSpot, Salesforce, and even Amazon. But, how to do it?

There are two ways you can use your data. You can select the data you want to see in your visualization tool (or use one that the service provides), or you can decide that it is easier to start with the pre-made template. Both approaches are equally good, and it all depends on your preference and expertise level. For beginners, it is always easier to use the templates.

[v-shex-msft · Accepted solution]

Hi @pawelj795,

I'd like to suggest you use a web connector with Facebook API instead. Below is a link with some sample code to use web connector to get data from rest API with authorizations, you can take a look at it if helps.

Pull data from a REST API Authentication 

Regards,

Xiaxoin Sheng

[Anonymous]

https://dataslayer.ai/dataslayer-api-query-manager/ looks like a good option for this.   Currently trialling, seems quick and reliable

[pawelj795]

up