Forum Discussion

Drawyiana's avatar
Drawyiana
New Member
8 years ago
Solved

Facebook: (#100) Tried accessing nonexisting field (comments) on node type (Page)

Hello Power BI Community,   I could solve the problem by entering the code:   let Source = Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?limit=100"), #"Expanded object...
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi Drawyiana,

     

    After getting all Posts, please expand corresponding items following below sequence:

    object_link

    -> object_link.connections

    -> object_link.connections.comments

    -> object_link.connections.comments.object_link

    -> object_link.connections.comments.object_link.connections

    -> object_link.connections.comments.object_link.connections.comments

    -> object_link.connections.comments.object_link.connections.comments.message

     

    let
Source = Facebook.Graph("xxxxxxxx"),
#"Expanded object_link" = Table.ExpandRecordColumn(Source, "object_link", {"connections"}, {"object_link.connections"}),
#"Expanded object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link", "object_link.connections", {"comments"}, {"object_link.connections.comments"}),
#"Expanded object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections", "object_link.connections.comments", {"object_link"}, {"object_link.connections.comments.object_link"}),
#"Expanded object_link.connections.comments.object_link" = Table.ExpandRecordColumn(#"Expanded object_link.connections.comments", "object_link.connections.comments.object_link", {"connections"}, {"object_link.connections.comments.object_link.connections"}),
#"Expanded object_link.connections.comments.object_link.connections" = Table.ExpandRecordColumn(#"Expanded object_link.connections.comments.object_link", "object_link.connections.comments.object_link.connections", {"comments"}, {"object_link.connections.comments.object_link.connections.comments"}),
#"Expanded object_link.connections.comments.object_link.connections.comments" = Table.ExpandTableColumn(#"Expanded object_link.connections.comments.object_link.connections", "object_link.connections.comments.object_link.connections.comments", {"message"}, {"object_link.connections.comments.object_link.connections.comments.message"})
in
#"Expanded object_link.connections.comments.object_link.connections.comments"

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Drawyiana,

 

object_link

-> object_link.connections

-> object_link.connections.comments

-> object_link.connections.comments.object_link

-> object_link.connections.comments.object_link.connections

-> object_link.connections.comments.object_link.connections.comments

-> object_link.connections.comments.object_link.connections.comments.from

-> object_link.connections.comments.object_link.connections.comments.from.name

 

Best regards,

Yuliana Gu

Rod's avatar
Rod
Advocate II
8 years ago

Hi v-yulgu-msft,

 

Thanks for replying. Your answer also helped me on one of my dashboards.

 

Would you mind helping me aswell? I would like to get information on the users who comments on my page's posts, such as: gender, hometown, age, etc.

 

Any ideas?