Forum Discussion
Error on FB tutorial-Details: Facebook : (#100)-The 'limit' parameter should not exceed 100
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.
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
Hello,
Am still getting this error using the below Power BI Desktop version even after trying the workround of selecting --None-- and then appying the limit in Advanced Editor:
Version: 2.46.4732.581 64-bit (May 2017)
Can anyone suggest what am I doing wrong?
Regards
Nirav
try this one- remove the version part from uri and give limit value less than 100.
Looks like it is case-sensitive.
Just change 'Posts' to 'posts' in the URL:
Source = Facebook.Graph("https://graph.facebook.com/v2.2/microsoftbi/posts?limit=100")
Works for me.
