Forum Discussion

Colin's avatar
Colin
Frequent Visitor
10 years ago
Solved

Facebook Page Likes

Hi everyone,   I am building a dashboard for my Company's marketing department. So far, I have been able to load all of the data related to our page's "Posts" using the Get Data wizard with Faceboo...
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    I believe this is explicitly prevented by Facebook for either privacy and/or corporate IP purposes

DataChant's avatar
DataChant
Most Valuable Professional
10 years ago

You can get the number of likes by manipulating the Facebook Graph API URL in the Query formula to call for the [page]/insights/page_fans metric.

 

Here is an example (modify the page name which is highlighted in bold)

 

 

let
    Source = Facebook.Graph("https://graph.facebook.com/v2.2/datachantblog/insights/page_fans"),
    #"Removed Other Columns" = Table.SelectColumns(Source,{"values"}),
    #"Expanded values" = Table.ExpandTableColumn(#"Removed Other Columns", "values", {"value", "end_time"}, {"value", "end_time"})
in
    #"Expanded values"

If you are considering a rebust Facebook dashboard with Power BI, you can learn some cool tips and tricks in my blog.

Feel free to contact me if you have any further questions.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hello DataChant,

 

I tried to apply the solution that you indicated, but this one has an authentication error and is already authenticated, what can I do?

 

  • Gferreira's avatar
    Gferreira
    New Member
    8 years ago

    I had the same problemn. You should to logout to Facebook, then login again. Get new token and use it on Power BI.