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

[Drawyiana]

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:

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

Regards

[v-yulgu-msft · Accepted solution]

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]

Thank you so much! I finally can see all replies to one post.

Is there also the possibility to see the user names / id´s of the repliers?

Regards,

Sebastian

[v-yulgu-msft]

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]

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?

[Drawyiana]

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:

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

Regards