facebook "limit reached #17" in Power Query in Excel

[CyrilMoysset]

Hello, 

I had extract 6 millions rows on tuesday ( I save that in a connection to transform in Power Pivot ) but today I can't extract more than 100k rows.

Nothing relevant is written in Facebook API seetings about limit #17. If someone have some information... 

I can't log in with an other facebook account in Query, do you know the reason ? 

Regards, 

[v-shex-msft · Accepted solution]

Hi @CyrilMoysset,

>>For my limit reached #17, is it power BI app than inflict limit or Facebook ?

I think it is more related to facebook.

Regards,

Xiaoxin Sheng

[v-shex-msft]

Hi @CyrilMoysset,

>>Nothing relevant is written in Facebook API seetings about limit #17

Based on document, I find the error message will appear when you frequent operation or deal with a large number of records(it not a static number and I don't know how to calculate the limit amount)

>>I can't log in with an other facebook account in Query, do you know the reason ? 

Did you clear up the certificate cache before you change the account?

In addition, can you share some detail information about your operation queries? It will be help for troubleshooting.

Regards,

Xiaoxin Sheng

[CyrilMoysset]

Hey,

Ok thank you very much for facebook limit reached #17

I try again to load my data with my present account and after i will try your soltion

For my query : I have loaded 25k posts on average and now i would pick up posts.likes ; posts.comments ... I know it's possible but how often in a time interval ? I don't know, it's this "limit reached #17" I will get a better understranding 

Thank you again 

[CyrilMoysset]

Hello, @v-shex-msft

To change account, I have refused Power BI application in facebook and that works.

For my limit reached #17, is it power BI app than inflict limit or Facebook ?

[v-shex-msft · Accepted solution]

Hi @CyrilMoysset,

>>For my limit reached #17, is it power BI app than inflict limit or Facebook ?

I think it is more related to facebook.

Regards,

Xiaoxin Sheng

[CyrilMoysset · Accepted solution]

Ok 

Thank you very much