Showing results for 
Search instead for 
Did you mean: 
AntoineCh Regular Visitor
Regular Visitor

facebook connector questions

Hi all,


I'm currently working on a facebook dashboard. I'm pulling the following data using the page_id, and my questions regarding them:


  1. "Insights" from the page
    • Lifetime likes from which you can derive likes from each day
    • Number of unique users "talking about the page" => what does that mean ? Shares ?
    1. Apparently you can't pull a page's insights with facebook graph API in v2.8. Therefore, i'm using v2.6. Any drawback I should be aware of ?
    2. Is it as I understand ; there are only 2 kpis with no page view count ?

     2. Shares, comments and likes from the page, but also peoples' data when their profile are public

    1. I can't find the shares accross the tables in the data I pulled
    2. I'm having trouble with that last item. I'm pretty sure it's possible, but i get all tables (books, feed, etc.) are empty and permissions throws an error (see attached):

"DataSource.Error: Facebook: (#100) Cannot request permissions of other users





When i enter it in the browser, it looks like I need an access token (from google graph API ?). But I wouldn't know where to fit that token, there is no such parameter anywhere in my code.


     3. Any other useful data I'm missing and that I can get legally on fb ?



Thanks for your help !




Here's the mother query I use to pull data for 2.:



    page_id = "XXXXXXXXXXXXXX",

    get_from_facebook = get_from_facebook(page_id),

    SampleOrNot = if SampleOrNot = false then get_from_facebook else Table.FirstN(get_from_facebook, SampleOrNot as number),

    #"Expanded object_link" = Table.ExpandRecordColumn(SampleOrNot, "object_link", {"created_time", "message", "connections"}, {"post.timestamp", "post.message", "post.connections"}),

    #"Added Index" = Table.AddIndexColumn(#"Expanded object_link", "", 1, 1),

    #"Changed Type" = Table.TransformColumnTypes(#"Added Index",{{"story", type text}, {"post.message", type text}, {"post.timestamp", type datetime}}),

    #"Inserted Date" = Table.AddColumn(#"Changed Type", "", each DateTime.Date([post.timestamp]), type date),

    #"Inserted Time" = Table.AddColumn(#"Inserted Date", "post.time", each DateTime.Time([post.timestamp]), type time),

    #"Removed Other Columns" = Table.SelectColumns(#"Inserted Time",{"story", "", "post.timestamp", "", "post.time", "post.message", "post.connections"})


    #"Removed Other Columns"



Where SampleOrNot is a parameter = 3 and get_from_facebook is:


// to be added: type parameter, date parameter


    from_facebook = (page_id as text) => Facebook.Graph(""

                                                        & page_id

                                                        & "/feed?limit=100")




customer data fb.JPG

v-ljerr-msft Super Contributor
Super Contributor

Re: facebook connector questions

Hi @AntoineCh,


As the Facebook connector in Power BI Desktop relies on the Facebook Graph API, and it seems that most of your questions are related to the Facebook Graph API itself, I would suggest that you also post the questions on the Facebook forums for better assistance. Smiley Happy



AntoineCh Regular Visitor
Regular Visitor

Re: facebook connector questions

Hi @v-ljerr-msft,


Not really, no. My questions are mostly on what you can do through the connector, and whether or not it's enough to do what I want to do. I've read some documentation on the api, but I'm wondering if I can reproduce the output through the connector.