Forum Discussion
helviobrito
9 years agoNew Member
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 (comm...
v-ljerr-msft
Microsoft Employee
9 years agoHi 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
Drawyiana
8 years agoNew Member
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