Forum Discussion
Getting Facebook likes, comments and shares count
Impactful IndividualI got it to run in the end although its a bit flakey and falls over alot, refreshing the query seems to do the trick but thanks for the suggested workaround.
The number of posts in the page I'm looking at was only about 800 which doesn't seem a lot, asside from the unexpected error I also sometimes get an error asking me to reduce amount of data requested, again a refresh resolves.
The whole process It is very slow but I guess thats how facebook want it. Things seem to have improved a bit now its no longer lunch time, I guess FB throttle the API at busy times.
Yeah - still trying to justify the value of doing this. At the very least this query is able to populate all the posts easily so if I were to do it by hand that already saves a bit of the work.
It is automation, but a very slow one at that. I was hoping for a faster way. Oh well - maybe we'll see better solutions down the road.
What do you mean by the FaceBook fields in the Power BI such as:
Caption
Id
Description
created_time
Icon
Is_expired
Is_hidden
Link
Message
Name
Object_id
Picture
Source
Status_type
Story
Type
Updated_time
?
I cannot find any information in the internet. Help me please.
