Chants of big data & bigger insights



Facebook Insights Bug

If you use Excel and Power BI Facebook connector to read page insights, you should be aware of this recent bug.

Till it gets fixed, you cannot read most of the metrics for your page using Excel and Power BI.
Thank you Tessa from Power BI team for pointing me to this bug, and to you, Borut for discovering it.


An update for the brave analysts of Facebook Insights and #PowerQuery

Update: 6/6/2016: This blog post provided a workaround to a Facebook bug which had been recently fixed.

If you tried my last Power BI tutorials here and here, and you are authoring reports that require the extraction of Facebook Page Insights, you may find today’s update useful.

So recently Facebook introduced the new reaction buttons. Unfortunately as it seems, the new features introduced new bugs in Facebook Graph APIs. On my last post I mentioned a bug in the counting of the new reactions (e.g. Love, Sad & Angry). But today I would like to focus on a new painful bug that makes my previous dashboards nonoperational.

The bug here, which was confirmed by Facebook, causes the insights/page_fans_country entry point to return no data (And my gut feeling tells me that there are probably dozens more related bugs).

Luckily, there is a simple workaround for my Facebook dashboards (the workaround is already implemented and is available here. Please don’t download the main file. Scroll down till you see the link at the Update section).  You should note that for some typical Facebook API issue, the data will be limited in its time span, and for certain pages (e.g. Tableau) data will only start showing from a specific date (See the following screenshot).


Continue reading “An update for the brave analysts of Facebook Insights and #PowerQuery”

Blog at

Up ↑