Forum Discussion

wildtxsue's avatar
wildtxsue
Regular Visitor
9 years ago
Solved

Error on FB tutorial-Details: Facebook : (#100)-The 'limit' parameter should not exceed 100

Cross posted from Integrations- I am trying to complete the FB tutorial (using microsoftbi posts) and repeatedly get the error = Details: Facebook : (#100)-The 'limit' parameter should not exceed 1...
Need Help
  • wildtxsue's avatar
    wildtxsue
    9 years ago

    I think I found the root cause: The April update to the PowerBI desktop client. Checked in with a collegue who still had the March version and the connector worked for him. Upgraded his client and he got the same errors.

     

    Will checkout the May release.

dcanalesg's avatar
dcanalesg
Regular Visitor
9 years ago

After you select facebook from Get Data, on the ' "Me", user name or Objetct ID ' dialog, insert microsoftbi or whatever page you are trying to connect to. On ' "Connection" ' select --None--. Then go to the Advanced Editor and add the following to the query: /posts?limit=100

 

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