topic Re: Facebook API Call Limit in Developer

Facebook API Call Limit

Alexander24 — Tue, 25 Apr 2017 12:17:34 GMT

I see that Power BI Is now integrated with facebook, I have noticed that however whilst i can retrieve data for some pages, for others it gives back a data limit problem

e.g

Detail=https://graph.facebook.com/Starbucks/posts?limit=250

Can you advise on a workaround for this problem?

Thanks

Alexander

Re: Facebook API Call Limit

Eric_Zhang — Wed, 26 Apr 2017 08:15:12 GMT

@Alexander24 wrote:

Hi

I see that Power BI Is now integrated with facebook, I have noticed that however whilst i can retrieve data for some pages, for others it gives back a data limit problem

e.g

Detail=https://graph.facebook.com/Starbucks/posts?limit=250

Can you advise on a workaround for this problem?

Thanks

Alexander

@Alexander24

The limit not exceeding 100 is set by facebook API.

In your case, instead of choose "Posts"

Choose a blank connection instead.

Then in the advanced Editor, append the extra uri

You don't worry about limit=10 or limit=100, based on my test, it would finally retrieve all posts information from facebook. The limit only affect how many records the API returns in each call.

Re: Facebook API Call Limit

Alexander24 — Wed, 26 Apr 2017 12:52:57 GMT

Great thanks for that i have another question

A) i have created a power bi template where users can input a facebook page and get analytics, however i would like to create this in power bi embedded so that users dont need to download desktop, is there anyway you can pass this parameter in embedded?

Re: Facebook API Call Limit

nazreen79 — Mon, 22 May 2017 14:45:33 GMT

Hi Eric_Zhang,

Thanks for the great solution. However, I'm facing another problem where it doesn't show all the columns from facebook. It just show only 5 columns instead of 28 columns before this. If I'm not mistaken, it is because of the new version of facebook API v2.8.

Do you have any suggestion on the workaround for this problem?

Thanks,

Naz79

Re: Facebook API Call Limit

PankajSanwal — Thu, 08 Jun 2017 06:26:04 GMT

Hi,

Starting API v2.8 only 5 columns are retrieved, if you want anything more than that you need to mention that specifically using URL params as shown below. You can check the column list for posts here:

https://developers.facebook.com/docs/graph-api/reference/v2.9/post

Facebook.Graph("https://graph.facebook.com/v2.8/microsoftbi/posts?fields=id,
admin_creator,
application,
call_to_action,
caption,
created_time,
description,
feed_targeting,
from,
icon,
instagram_eligibility,
is_hidden,
is_instagram_eligible,
is_published,
link,
message,
message_tags,
name,
object_id,
parent_id,
permalink_url,
picture,
place,
privacy,
properties,
shares,
source,
status_type,
story,
story_tags,
targeting,
to,
type,
updated_time,
with_tags&limit=100")

Cheers!!!

Re: Facebook API Call Limit

viragjagtap — Fri, 14 Jul 2017 13:37:32 GMT

Thanks a lot.