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
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.

  • DataChant's avatar
    DataChant
    Icon for Most Valuable Professional rankMost Valuable Professional
    8 years ago
    Hi Anonymous
    You cannot read insights any longer using the Facebook connector. If you are an admin of the page you can still do it using Web.Contents, but you will need to get a page access token, which are challenging to get if you are not developer. Will you be satisfied with a report that requires contact manual update to the access token?
  • gabriel_264's avatar
    gabriel_264
    Frequent Visitor
    8 years ago

    Good morning! What do you mean by "web.contents"? I'm facing the same problem but can't figure it out.

     

    Thanks!