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

procyon82's avatar
procyon82
Icon for Resolver I rankResolver I
10 years ago

What about page likes without knowing who liked your page. How do you get that?

DataChant's avatar
DataChant
Icon for Most Valuable Professional rankMost Valuable Professional
10 years ago

Here is an example with Web.Contents to get your Facebook Likes:

 

let
    YourFacebookObjectName = "datachantblog",
    YourAccessToken = "Get the token from Facebook Graph Explorer, or APIGEE",
    Source = Json.Document(Web.Contents("https://graph.facebook.com/v2.7/" & YourFacebookObjectName & "/insights/page_fans?access_token=" & YourAccessToken)),
    data = Source[data],
    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"values"}, {"values"}),
    #"Expanded values" = Table.ExpandListColumn(#"Expanded Column1", "values"),
    #"Expanded values1" = Table.ExpandRecordColumn(#"Expanded values", "values", {"value", "end_time"}, {"value", "end_time"})
in
    #"Expanded values1"

 

  • jessicaf31's avatar
    jessicaf31
    Icon for Advocate I rankAdvocate I
    9 years ago

    Hi DataChant,

     

    I've tried to do what you just described, but I have an error: Column1 has not been found...

    Do you know why ?

     

    Thanks !!

     

    • DataChant's avatar
      DataChant
      Icon for Most Valuable Professional rankMost Valuable Professional
      8 years ago

      Can you please share the M expression?

      Facebook made some changes recently, and you cannot use the Facebook connector to read user likes.

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        DataChant
        Of course, 

         

        let
        Source = Facebook.Graph("https://graph.facebook.com/v2.2/rgmtecnologia/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"

         

         

        I can no longer read the tanned of the users? Is there another way to get this information for power bi?

         

         

        Thanks for your help.

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi,

       

      I too have this error.

       

      Thanks

  • procyon82's avatar
    procyon82
    Icon for Resolver I rankResolver I
    10 years ago

    Thanks. I played around in the Graph API Explorer and found 'fan_count'. The following seems to do the trick.

    = Facebook.Graph("https://graph.facebook.com/v2.7/pagename?fields=fan_count")

    How do I combine this with dates, so that I can show page likes growth over time?

     

    Engagenment also works, but again I don't know how to combine this with a date.

    = Facebook.Graph("https://graph.facebook.com/v2.7/pagename?fields=engagement")
    • DataChant's avatar
      DataChant
      Icon for Most Valuable Professional rankMost Valuable Professional
      10 years ago

      Try to use the field since as a parameter in the URL. More details here.

       

      • sarafenwick's avatar
        sarafenwick
        Frequent Visitor
        9 years ago

        I'm having trouble getting the since function to work in conjunction with the access token... can you provide how you would modify the below to include a since period? 

         

        let
            YourFacebookObjectName = "datachantblog",
            YourAccessToken = "Get the token from Facebook Graph Explorer, or APIGEE",
    Source = Json.Document(Web.Contents("https://graph.facebook.com/v2.7/" & YourFacebookObjectName & "/insights/page_fans?access_token=" & YourAccessToken)),
    data = Source[data],
    #"Converted to Table" = Table.FromList(data, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"values"}, {"values"}),
    #"Expanded values" = Table.ExpandListColumn(#"Expanded Column1", "values"),
    #"Expanded values1" = Table.ExpandRecordColumn(#"Expanded values", "values", {"value", "end_time"}, {"value", "end_time"})
in
    #"Expanded values1"
    • DataChant's avatar
      DataChant
      Icon for Most Valuable Professional rankMost Valuable Professional
      10 years ago

      Procyon82, try to use the field since as a parameter in the URL. More details here.

       

      • procyon82's avatar
        procyon82
        Icon for Resolver I rankResolver I
        10 years ago

        I tried that using unix timestamp, but it just gives me today's total page likes. How do others answer questions regarding page like growth? It can't be that hard...