facebook limit post is not working

[danbrow]

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")

[v-yuezhe-msft]

@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

[danbrow]

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")"

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

[v-yuezhe-msft · Accepted solution]

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


Regards,
Lydia

[danbrow]

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. 

[v-yuezhe-msft]

@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