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
Icon for Most Valuable Professional rankMost 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.