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

[helviobrito]

Hi, people.

Can anyone help me? I'm trying to create a report based on a Facebook page comments. But Power BI returns the error bellow:

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

The problem is that the Facebook page has numerous comments. I checked the page settings and saw nothing that could be blocking them.

What is happening? How can I solve this?

[v-ljerr-msft]

Hi @helviobrito,

Based on my test, we may need to get all posts first, then expand the object_link > expand object_link.connections > expand object_link.connections.comments to get comments for each post. The M query below is for your reference. 

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"

Regards

[Drawyiana]

Great! Worked for me. 

Now the question is how I can see the replies of the comments, so my order would be:

post -> comment -> replies of the comment

Is that possible?

Regards