Display Facebook Feed In Power BI

So far in this series, I wrote:

1. Getting Started with Power BI Desktop
2. Create SQL Reports with Power BI
3. Create Power BI Report with Microsoft Access Database
4. How to publish BI Reports

This article explains how to get Facebook feed and display in a Power BI report.

Getting Started

Start Power BI Desktop and click on the Get Data from the list in the left side bar as you can see in Figure 1.

Figure 1

Select all from the left side and select Facebook and click Connect button.

Figure 2

Next you will see this warning message. Just click Continue button.

Figure 3

Now provide Facebook username or object id or connection and click OK.

Figure 4

You can select the connection you want to display, here is list.

Figure 5

Here you can put Facebook username or object id or you can put just Me.

Figure 6

Now you need to authenticate Facebook. Just click Sign In button.

Figure 7

Enter Facebook login credentials and click Log In.

Figure 8

Power BI needs to access your Facebook public details like profile, friend list, email address, Timeline posts, status updates, personal description and likes and click Okay button.

Figure 9

Now allow Microsoft Power BI to access Page and insights, Click Okay button.

Figure 10

Here your credentials are authenticated, as you can see there is no Sign In button displaying. Now click Connect button.

Figure 11

In this post I will get my Facebook Feeds only, You can select whatever you want to display and click OK button.

Figure 12

Here you can see list of all Facebook feed messages, Click Load button.

Figure 13

Figure 14

Now select the columns you want to display in Visualization. Here I am going to display my feeds in a Table.

Figure 15

Now finally in result you can see all feed message in a table.

Figure 16

Summary

In this article, we saw how to get Facebook feed and generate charts and reports in Power BI.