Connect to Facebook (Power Query)
In the Power Query ribbon tab, click From Other Sources > From Facebook.
In the Facebook dialog box, connect to Facebook using “Me”, your Username, or Object ID.
In the Connection name list, select a node to connect to. For example, select FriendLists to give you access to all information available in your Facebook FriendLists category.
After the connection succeeds, you will be able to preview a table containing information about the selected category. For instance, if you select the Friends category, Power Query renders a table containing your Facebook friends by name, and you can expand other information about your friends from the last column in the table.
You can use the Query Editor to write formulas for Power Query.