Forum Discussion
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.
- 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.
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
= 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.
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.
- 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.