Unable to import data sources from Facebook using the Get and Transform (Power Query) feature in Excel


Cause

Facebook Get & Transform (Power Query) is a feature that allows the user to import and refresh data from Facebook in Excel. The Facebook Get & Transform data connector feature was retired on April 1, 2020. This change means that you will be unable to import data sources from Facebook using the Get & Transform (Power Query) feature in Excel. You will receive an error message upon trying to import Facebook data.

example screenshot

Resolution

Remove any existing Get & Transform (Power Query) queries that import data from Facebook.