Forum Discussion
Facebook Data Connector
It is being fully depreciated. They are removing the facebook connector from Excel in April 2020. I would expect this to vanish from Power BI too in the near future. You should look for an alternative source, or getting the API to working better for your needs.
"Important: Retirement of Facebook data connector notice Import and refresh data from Facebook in Excel will stop working in April, 2020. You will still be able to use the Facebook Get & Transform (Power Query) connector until then, but starting in April, 2020, you will be unable to connect to Facebook and will receive an error message. We recommend revising or removing any existing Get & Transform (Power Query) queries that use the Facebook connector as soon as possible to avoid unexpected results."
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/