Facebook connector: Empty likes table

[pavelveret]

I'm trying to get posts from my Facebook page using PowerBI Facebook connector, but tables in likes column are empty.

I will be grateful for the advice.

Query code:

let
 Source = Facebook.Graph("https://graph.facebook.com/v2.8/{page_id}/posts"),
 #"Expanded object_link" = Table.ExpandRecordColumn(Source, "object_link", {"connections"}, {"connections"}),
 #"Expanded connections" = Table.ExpandRecordColumn(#"Expanded object_link", "connections", {"comments", "likes"}, {"comments", "likes"})
in
 #"Expanded connections"

Everything is ok with comments, i can extract aggregated data of comments count:

Here is what i have with likes:

[Rod · Accepted solution]

For some reason after the latest API update by Facebook I can only get Likes information from posts created until November/2017. Any posts created after that results on empty Likes table ...

I have a big facebook dashboard on my company's page and now graphs are all messed up!

Hope Facebook or Microsoft can work something out real quickly because I couldn't find a workaround.

[v-shex-msft]

Hi @pavelveret,

If you test with other methods, can you get data from current api url? I'd like to suggest you check on api first if current result not contains any record comment.

Regards,

Xiaoxin Sheng

[pavelveret]

= Facebook.Graph("https://graph.facebook.com/v2.8/{page id}/")

With this URL i get a list with information about my page: name, id, connections. Connections Record contains tables: feed, likes, posts (API Methods, I believe).

`Posts` and `feed` returns a table with all posts. `Likes` table is empty.

`Posts` and `feed` tables has `object_link`. If i Expand it, i get `connections`, which i can expand to `comments` and `likes`. Everything's ok with comments, but `likes` column is still empty.

[Rod · Accepted solution]

For some reason after the latest API update by Facebook I can only get Likes information from posts created until November/2017. Any posts created after that results on empty Likes table ...

I have a big facebook dashboard on my company's page and now graphs are all messed up!

Hope Facebook or Microsoft can work something out real quickly because I couldn't find a workaround.

[brunovarela]

Do you know if thre's any updates on this ? 

[DataChant · Accepted solution]

I have a developed advanced M queries that import the total likes per post.

The reason you cannot import likes is that Facebook changed their policies. Only page administrators can now import likes with user ids, and only using a page token. Power BI Desktop Facebook connector relies on the user token, not the page token.

There is a way to get the total number of likes per post, and bypass the current limitations, if you use the web connector, and an advanced M + Graph API code. You can see a working report here: https://datachant.com/downloads/facebook-analytics-dashboard-including-reactions/

As a temporary solution, you can count the number of shares per post, using the parameter “fields=shares” in the Facebook.Graph URL.
An example for the implementation of the shares can be found here:
https://datachant.com/downloads/facebook-dashboard/

I am sorry that I cannot reveal more. If it is crucial to your business, feel free to contact me in a private message.