How to extract facebook data from PowerBI
How to extract facebook data from PowerBI,PowerBI significantly improved the function of data pull from facebook since its inception.
Install Power BI and create account in Facebook(for Access token)
Create new file -extension is .PBIX and click get data. Select Facebook from the list.
Enter Facebook credentials to connect Graph API in FB & PowerBI. This step actually pulls the access token from facebook.
Once you are connected to facebook,you have to provide the facebook page name like below.Have added shoppersstopindia for reference.
Once, you click the ok button PowerBI will create the query and it will create the following table
Step 6 :
You can create reports using the above columns!!!. You need to create Like,Comment and share table with some tweaks … to create following report!