Getting Facebook likes, comments and shares count

Thanks vasim07 that's what I suspected it was - good to have someone else with more expertise confirm this. However, I guess the main problem is the aggregation part - seems to rely heavily on the FB graph which is very very slow - guess there isn't a faster way to do this? 

itchyeyeballs your problem is because the page you are trying to call from has too many posts - and I would guess that Facebook has a limitation as to how much data you can call in a single query. 

Here's what I've done as a workaround - first of all when you pick what kind of data you'd like to get from Facebook, pick 'Statuses' instead of 'Posts'. Usually that does the trick and you'll be able to get some data first. Then once the window pops up you click "Edit". 

Clicking edit will bring up the query. You then select "Advanced Editor" in which a pop up will appear with some code. Change to the following format:

This is the original format:

let
Source = Facebook.Graph("https://graph.facebook.com/v2.2/PAGENAMEHERE/statuses")
in
Source

--------

Now the changes you have to make:

1. Change 'statuses' at the end to 'posts' - because you want posts.

2. You will need to set a limit as to how much data you are pulling from Facebook, so add the following after statuses: ?limit=100

The number 100 is quite arbitrary but basically adjust it until you are able to pull data. 

Looks like this:

let
Source = Facebook.Graph("https://graph.facebook.com/v2.2/PAGENAMEHERE/statuses?limit=100")
in
Source

If you wish, you can even set some date parameters so the system will only pull in posts with the limit and between the dates you set:

let
Source = Facebook.Graph("https://graph.facebook.com/v2.2/PAGENAMEHERE/statuses?limit=100&since=2012-10-20&until=2012-12-31")
in
Source

This should solve your problem with the errors.

Meanwhile I'm still waiting for the FB graph to finish aggregating..sigh..there's got to be a better and faster way..