Facebook Power BI Integration

We from Agile BI hold lots of events and workshops during the year. We love to teach and inspire our attendees. But we also love the fact that we get at every workshop something back – feedback, contacts or inspiring questions. After every workshop our team comes together again and reflects the workshop. At this point we choose the most inspiring question from one of our attendees that we answer here again with some additional material. Either our attendees from our last workshop can read it again or our community gets new information that they have not known yet.

The question of the day was at our last SQL Server jumpstart and Power BI workshop on the 18th June 2015.

This question came straight after lunch break up, which is even more admirable as most of us are a bit tired after lunch and not even able to function.

Iman talked about the integration of Data into Power BI. And then the question came up:

question-of-the-day

Can I integrate data from Facebook into Power Query and Power BI? If yes how can I do that?

Answer: Yes you can! And here is a description of how to do that.

Step 1: Choose a Facebook page of your interest. Can be your own Facebook page as well.

Step 2: Open Excel and click on the Power Query button in the home tab. From there navigate to “From other sources” and here you can find straight away the option “From Facebook”.

1step

Step 3: After clicking this, a window opens where you can either fill in your User ID “Me” (to analyse your own Facebook profile) or any “Object ID” that is any other profile you want to analyse and for that you have to insert the last numbers at the end of the URL of the Facebook page you want to analyse.

2

The choice below is which “Connection” you want to choose, these can be things like, Friends, Likes, Posts,…(whatever you want to analyse) Press “OK” to confirm your choices.

Step 4: After that Facebook will ask you to login with your login data, as you normally do on Facebook.

3

Step 5: Depending on your internet connection your data will be loaded quickly from Facebook directly into Power Query. From there you can use the data to analyse it in Excel.

Step 6: Here we are going to show you how to do this in the new Power BI Designer. The previous steps are exactly the same. In “Report View” you can specify how you want to visualise your report. You can change it to “Treemap” or to any other visualisation you choose.

4

Step 7: Any time after you imported your data and started visualising you can perform various data shaping and cleansing steps in order to get the most out of your data.

Step 8: After that you can load the resulting table into your report and create additional visualizations. Change between “Report” and “Query”.

5

Step 9: Update and resize the visualizations as you need it. Hit refresh at any point to include the latest data in your report.

6

Power Query is a beneficial feature of Power BI. You can use Power Query to connect to data from public and private data sources.These are powerful and easy to use tools to analyse and visualise your data. Do not forget that you are also able to create dashboards that you can share with others.

Thank you Iman for answering again this excellent question.

Contact us for any questions.

If you have any questions about Power BI, we from Agile BI support you to gain information about Power BI with the following options:

  • Come to one of our introductory or intermediate Power BI workshops in Sydney. The next one happens soon, check here for details of upcoming courses.
  • Or we come to you and show you in a Power BI demo session what is possible

Email us today to find out more about Power BI

The following two tabs change content below.

Kathrin Haitzer

Kathrin is an experienced Marketing Consultant who worked for advertising and public relations agencies, website and image companies in Vienna, Munich and Sydney. Her expertise are digital marketing and social media for Agile BI.