Forum Discussion
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 100
I have installed the most current version of PowerBI desktop.
How can I get past this problem?
Thanks much!!!
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.
9 Replies
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
SourceHello,
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
mkumarAdvocate I
try this one- remove the version part from uri and give limit value less than 100.
- MarcelBeug
Community Champion
Probably nobody in this forum knows those tutorials. Can you provide a link?
- MarcelBeug
I get the same error at step 4 of task 1.
It must be some issue inside the connector that we are not able to see.
As a workaround you can create a blank query and start with the code step from the end result of the tutorial:
= Facebook.Graph("https://graph.facebook.com/microsoftbi/posts")
My suggestion would be to provide feedback on the tutorial page stating that the information on that page is not helpful and formulate the issue.
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.
