Empty table querying Facebook comments from Excel 2016 RRS feed

  • Question

  • I'm trying out Excel 2016's feature in Get & Transform to query Facebook. I'm able to return "feed" and "likes" and get tables of expected results. But when I query "comments" or "friends", I get an empty table.

    Facebook itself, looking at my activity log, shows that I have plenty of recent comments. And of course friends too. 

    Why would I be unable to return "comments" and "friends", when "feed" and "likes" work fine?

    Monday, November 13, 2017 4:56 AM


  • Please share the code from your advanced editor so that we can see how you connected to FB.

    Imke Feldmann - MVP Data Platform (PowerBI) - http://www.TheBIccountant.com 

    Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to vote it as helpful - Thanks!

    Monday, November 13, 2017 7:11 AM