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

mfmom's avatar
mfmom
New Member
10 years ago

I confirm that this is not working anymore. Calls to the Facebook API metrics /insights/* just hang forever "waiting for graph.facebook.com". Something must be broken with the PowerBI Facebook connector. Can anyone help?

DataChant's avatar
DataChant
Icon for Most Valuable Professional rankMost Valuable Professional
10 years ago
The best way to get Facebook data at this stage is to use the Web Connector. You can follow my blog http://datachant.com for many examples.
  • 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 !!