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

[wildtxsue]

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!!!

[dcanalesg]

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

[Nirav]

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

[mzachariah]

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.

[mkumar]

try this one- remove the version part from uri and give limit value less than 100.

[wildtxsue · Accepted solution]

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.

[MarcelBeug]

Probably nobody in this forum knows those tutorials. Can you provide a link?

[wildtxsue]

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-tutorial-facebook-analytics/

apologies!

[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.

[wildtxsue]

Am afraid that workaround won't look good in a demo. Thanks for the idea...I have provided feedback on the tutorial page. Sure hope someone sees it before my demo!