cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Drawyiana Frequent Visitor
Frequent Visitor

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

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

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"

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5
Highlighted
Drawyiana Frequent Visitor
Frequent Visitor

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

Community Support Team
Community Support Team

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

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"

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Drawyiana Frequent Visitor
Frequent Visitor

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

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

Community Support Team
Community Support Team

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

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

1.PNG

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Rod Frequent Visitor
Frequent Visitor

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

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?