Forum Discussion

pawelj795's avatar
pawelj795
Post Prodigy
6 years ago
Solved

Facebook Analytics (connector)

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?

 

  • Anonymous's avatar
    Anonymous
    6 years ago

    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

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

  • 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.

  • 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.