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

Drawyiana's avatar
Drawyiana
New Member
8 years ago

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_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", {"created_time", "from", "message", "id", "object_link"}, {"object_link.connections.comments.created_time", "object_link.connections.comments.from", "object_link.connections.comments.message", "object_link.connections.comments.id", "object_link.connections.comments.object_link"})
in
    #"Expanded object_link.connections.comments"

 

But now my question is, if I can also see the replies of the comments? Is there another code?

 

So my desired order would look like this:

 

Post -> Comment -> Replies to the comments 

 

Kind of like this:

 

help.JPG

But I would also like to see all replies, so not only one single reply.

 

Regards