cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 108 members 1,617 guests
Please welcome our newest community members: