Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Franklin1
Advocate I
Advocate I

Facebook

Hello everyone,

 

I have created a few reports getting data from Facebook API.

The issue is that when I schedule refresh in PBI Service, there is an error related to the Facebook API as follows:

Facebook: (#17) User request limit reached Table:XXX

 

This error is related to the limitation of data in the query, and since there are few queries (of a few reports) running in parallel, it seems that i reached the limit, and the request is declined.

I understand the issue and the reasons for the error message.

 

My question is whether there is any workaround for this issue.

let's say I have a several reports I want to refresh all together, that reach the limitation as mentioned above.

How can I do it anyway? 

There must be a way of doing that.

 

Thanks a lot for all of you.

1 ACCEPTED SOLUTION
v-shex-msft
Community Support
Community Support

Hi @Franklin1,

 

Based on your error message, It sounds like you called API too many times so it reached to the daily limit.

I'd like to suggest you use switch the connect account and try again.

 

BTW, you can also take a look at below articles to know more about this issue.

Marketing API Rate Limiting

Avoiding "User request limit reached"

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

2 REPLIES 2
Adel
Helper III
Helper III

My advice would be to use a third-party connector, and a data warehouse depending on the volume of your data.
But windsor.ai would help you do that, here is the how to.
https://windsor.ai/how-to-connect-facebook-ads-to-power-bi/

v-shex-msft
Community Support
Community Support

Hi @Franklin1,

 

Based on your error message, It sounds like you called API too many times so it reached to the daily limit.

I'd like to suggest you use switch the connect account and try again.

 

BTW, you can also take a look at below articles to know more about this issue.

Marketing API Rate Limiting

Avoiding "User request limit reached"

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors