Import Data From Facebook Using Power Query in Excel

I like Power Query day by day because it is very interesting. This tool is so good. We can import every external data from multiple sources.

Power Query is a very good and beneficial feature of Power BI. Power Query can be used to connect to data from public and private data sources. It merges data from multiple data sources for better analysis in Excel. Power Query has better capabilities to transform data. With Power Query business users can search an entire cloud data both public and private. Power Query enables the business users to search, combine, shape and also download data with multiple sources.

This article describes how to open Facebook using Power Query in Excel and also how to get data from Facebook using Power Query. There are some basic procedures to understand how to open Facebook using Power Query in Excel.

Step 1: Open Excel sheet

The first and major step is to open an Excel sheet.



Step 2: Select Power Query

The second step is to select Power Query from the menu bar.



Step 3: Select from other sources option

Now the next step is to select the from other sources option from Power Query.



When you select this option then it shows various options to import data from external sources.



Step 4: Select Facebook option

When this list is opened then select the Facebook option.



Step 5: Specify object or connection

After selecting the option Facebook then this box will be opened and here the user specified an object and connection of what the user wants. Then click on the OK button.

In Facebook there are the following three types of connections: