Facebook as a Data Source

[Lilsaint]

Hello guys, has anyone tried using facebook as a data source in power bi and how did they go about it? I have about 9 business pages that I want to connect to and report on their performance

[ReportMaster]

Hi @Lilsaint as other comment mentioned, Fb native integration to PBI is not available anymore so you will have to connect using some M code or using an external connector, which I think it's the best option because it saves you a lot of time. 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. The same applies if you wish to connect either Facebook organic or Facebook Leads connector

[EugeneLebedev]

You can either write your own code to extract data from Facebook or you can get this code off the shelf. Here is a ready-made solution for connecting Power BI to Facebook Ads: https://vidi-corp.com/facebook-ads-connector-to-power-bi-looker/

[v-yilong-msft · Accepted solution]

Hi @Lilsaint ,

It seems that the Facebook connector is gone for real since April 2020, if you want to connect data on Facebook to Power BI, you can use Google Sheet and here is the link about how to use it: How to connect Facebook to Microsoft Power BI | by Paul Vella | Ones & Zeroes | Medium

Another method is that you can use a web connector with Facebook API.

I think you can also read this topic for a further study: Solved: Facebook Analytics (connector) - Microsoft Fabric Community

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.