Forum Discussion

jessicaf31's avatar
jessicaf31
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Error - failed to save modifications to the server : Facebook likes

Hello,   I try to analyze the likes evolution of my page, I put that code in the  Advanced Editor :    let Source = Facebook.Graph("https://graph.facebook.com/v2.7/[MYPAGENAME]/insights/page_fan...
Need Help
  • Datatouille's avatar
    Datatouille
    8 years ago

    Hi,

     

    This Facebook connector is still not very stable mainly because Facebook often changes the structure of its APIs...

     

    This should somehow work:

    = Facebook.Graph("https://graph.facebook.com/v2.8/[YourFacebookPageName]/insights/page_fans?since=2016-12-31")[values]{0}

     

    The green part of the code allows me to force Power Query to get the first table included in the list of tables ([values]) available.

     

    This code also works:

    = Facebook.Graph("https://graph.facebook.com/v2.8/[YourFacebookPageName]/insights/page_fans?since=2017-12-31"){0}[values]

     

    In this case, I am getting the 1st full record of the Query and then the table included in the [values] element of this 1st record.

Datatouille's avatar
Datatouille
Icon for Solution Sage rankSolution Sage
8 years ago

Hi,

 

This Facebook connector is still not very stable mainly because Facebook often changes the structure of its APIs...

 

This should somehow work:

= Facebook.Graph("https://graph.facebook.com/v2.8/[YourFacebookPageName]/insights/page_fans?since=2016-12-31")[values]{0}

 

The green part of the code allows me to force Power Query to get the first table included in the list of tables ([values]) available.

 

This code also works:

= Facebook.Graph("https://graph.facebook.com/v2.8/[YourFacebookPageName]/insights/page_fans?since=2017-12-31"){0}[values]

 

In this case, I am getting the 1st full record of the Query and then the table included in the [values] element of this 1st record.