cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wildtxsue Frequent Visitor
Frequent Visitor

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
wildtxsue Frequent Visitor
Frequent Visitor

Re: 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.

View solution in original post

9 REPLIES 9
MarcelBeug Super Contributor
Super Contributor

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

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

Specializing in Power Query Formula Language (M)
wildtxsue Frequent Visitor
Frequent Visitor

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

MarcelBeug Super Contributor
Super Contributor

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

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.

Specializing in Power Query Formula Language (M)
wildtxsue Frequent Visitor
Frequent Visitor

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

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!

wildtxsue Frequent Visitor
Frequent Visitor

Re: 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.

View solution in original post

dcanalesg Frequent Visitor
Frequent Visitor

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

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 Occasional Visitor
Occasional Visitor

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

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

mkumar Visitor
Visitor

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

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

mzachariah New Member
New Member

Re: Error on FB tutorial-Details: Facebook : (#100)-The 'limit' parameter should not exceed 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.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 206 members 2,253 guests
Please welcome our newest community members: