Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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")
Solved! Go to 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,
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
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.
@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
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |