Forum Discussion
Facebook: (#100) Tried accessing nonexisting field (comments) on node type (Page)
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?
2 Replies
v-ljerr-msftMicrosoft Employee
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. :smileyhappy:
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
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
