cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

facebook limit post is not working

Hello everyone,

I'm with difficult to limit the return the posts quantity of Facebook. This code below is not working !!

Facebook.Graph("https://graph.facebook.com/v2.8/[facebook-id]/posts?limit=100")

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Microsoft
Microsoft

Re: facebook limit post is not working

@danbrow,

I guess that you don't have more than 100 posts 4 months before? Please check the knowledge base post by Eric.

In your scenario, you can keep top 100 rows by selecting the following option.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Microsoft
Microsoft

Re: facebook limit post is not working

@danbrow,

Based on my test, no matter which limit value you set in the URL, it would finally retrieve all posts information from facebook. The limit only affect how many records the API returns in each call, it doesn't use to limit the whole post number in Power BI.


Regards,
Lydia

 

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
New Member

Re: facebook limit post is not working

Firtly, Thx for the answer.

  like you said "The limit only affect how many records the API returns in each call" i ithink that each record is a post.  So, do you know how limit the return of records?

See how i'm using the facebook graph. Its returning more of 500 rows.

"= Facebook.Graph("https://graph.facebook.com/v2.8/793282314057999/posts?limit=50")"

LimitFace.png

 

Observation: Some time ago (about 4 months) i did exactly that i said and was working.

Highlighted
Microsoft
Microsoft

Re: facebook limit post is not working

@danbrow,

I guess that you don't have more than 100 posts 4 months before? Please check the knowledge base post by Eric.

In your scenario, you can keep top 100 rows by selecting the following option.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

Re: facebook limit post is not working

 

Do u understand this phrase "The limit only affect how many records the API returns in each call." ?

i keep the first top 10 post rows. This retrive about 20k likes rows and 8k comments rows. Limiting to 10 posts rows i get the load with sucefull. 

 

Highlighted
Microsoft
Microsoft

Re: facebook limit post is not working

@danbrow

You can check the returned records using Facebook Graph API Explorer, you will find that when you add limit parameter, it will return limited records in each call.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors