Forum Discussion

LucasLiachi's avatar
LucasLiachi
New Member
9 years ago
Solved

facebook

Hi! i try conect facebook, every datas. so this erros insist: "Facebook: (#100) The 'limit' parameter should not exceed 100" please, help me.

i try this solution https://community.powerbi.com/t5/Community-Knowledge-Base/Facebook-100-The-limit-parameter-should-not-exceed-100/ta-p/164790 but dont come all datas

but not solution

and haved more people with this problem:
https://community.powerbi.com/t5/Desktop/Error-on-FB-tutorial-Details-Facebook-100-The-limit-parameter/td-p/163599

And more
https://community.powerbi.com/t5/Desktop/Facebook-Data-limit-results/m-p/7445#M1051

  • Hi LucasLiachi,

     

    Based on my test with the latest version of Power BI Desktop, instead of adding "/Posts?limit=100", adding "/posts?limit=100" to the url in the Advanced Editor works for me. Could you go to check if it work in your scenario? :smileyhappy:

    = Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?limit=100")

     

    Regards

4 Replies

  • Hi LucasLiachi,

     

    As my observation, just use none in Connections with limit 100, it will load all data of page as my checking in June. 

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee

    Hi LucasLiachi,

     

    Based on my test with the latest version of Power BI Desktop, instead of adding "/Posts?limit=100", adding "/posts?limit=100" to the url in the Advanced Editor works for me. Could you go to check if it work in your scenario? :smileyhappy:

    = Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?limit=100")

     

    Regards