This article describes how to open Facebook using Power Query in Excel and also how to get data from Facebook using Power Query.
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 sheetThe first and major step is to open an Excel sheet.Step 2: Select Power QueryThe second step is to select Power Query from the menu bar.Step 3: Select from other sources optionNow 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 optionWhen this list is opened then select the Facebook option.Step 5: Specify object or connectionAfter 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:
None: If the user selects the "None" connection type then Power Query imports any data from Facebook.Activities: If the user selects the "Activities" connection type then Power Query imports the activities of the Facebook user from Facebook.Books: If the user selects the "Books" connection type then Power Query imports books of the Facebook user that he/she likes from Facebook.Example: Here in this example I select the object "Me" and select the connection as "Activities".Step 6: Requires login id and passwordThen it requires a login id and password of the Facebook user.
Pro WPF: Windows Presentation Foundation in .NET 3.0