cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
pavelveret Frequent Visitor
Frequent Visitor

Facebook connector: Empty likes table

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:

 

comments.PNG

 

Here is what i have with likes:

likes.PNG

2 ACCEPTED SOLUTIONS

Accepted Solutions
Rod Frequent Visitor
Frequent Visitor

Re: Facebook connector: Empty likes table

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.

DataChant Member
Member

Re: Facebook connector: Empty likes table

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.
4 REPLIES 4
Community Support Team
Community Support Team

Re: Facebook connector: Empty likes table

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
pavelveret Frequent Visitor
Frequent Visitor

Re: Facebook connector: Empty likes table

 

 

= 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).

 

fb.PNG

 

`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 Frequent Visitor
Frequent Visitor

Re: Facebook connector: Empty likes table

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.

DataChant Member
Member

Re: Facebook connector: Empty likes table

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.