Report Builder Not Refreshing | Community
Skip to main content
N
nbanburyBMW
October 26, 2022
Solved

Report Builder Not Refreshing

  • October 26, 2022
  • 2 replies
  • 1846 views

Hi all. I'm having a recurrence of a problem I had in July, where none of my Adobe Report Builder requests are refreshing. I can view them fine but when I try to update then just get stuck on "Refreshing" for a long time (I've left it for an hour and nothing has happened). 

I've tested a brand new request on a brand new sheet and the same issue applies.

 

It worked fine up until about 9am yesterday but has not been working since.

 

Are there any known issues with it at the moment?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Jennifer_Dungan

Yeah, I was thinking that wasn't the case.. let me reach out to some of my Adobe contacts and see if we can get you fixed up.

 

In the meantime, can you log out of the Report Builder plugin, restart Excel, then re-login, and make sure that it connects to your organization login (hopefully it prompts you). Just to make sure it's not a weird account thing?

2 replies

VaniBhemarasetty
Adobe Employee
VaniBhemarasettyAdobe Employee
Adobe Employee
October 26, 2022

 

@nbanburybmw  There are several reasons why the refresh of the report builder is taking a lot of time than expected. Report builder works on adobe analytics API and that has limitations

Report Builder supports workbooks up to the following limits:

  • 1000 requests: A single workbook can contain up to 1000 data requests. If you have reports or projects that require more than 1000 requests, Adobe recommends separating them into multiple workbooks.
  • 20K requests per hour per company: Report Builder uses the Analytics reporting API to retrieve data. Each individual request uses an API call whenever it is created or refreshed. If your organization accumulates more that 20,000 API calls in a given hour, you must wait until the next hour to retrieve data again.

If this limitation is met, the refresh will slow down and eventually just continues without completing.

 

Here is the documentation on how to optimize and best practice to be followed in report builder

https://experienceleague.adobe.com/docs/analytics/analyze/report-builder/troubleshoot.html?lang=en

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 26, 2022

Did you make any changes to your report? If not, then it's unlikely that you hit those API limitations....

 

I am testing one of my existing reports right now to see if I have any issues... but so far it seems to be progressing just fine.... 

Is it possible that you are authenticated with the new "personal account" (since Adobe split our emails into personal and organization based)? I know that there is still some inner connection between accounts that might be causing some confusion... maybe in one respect, it thinks you have access, and in another it thinks you don't... and that confusion is causing a failure to pull data but not to error out with a "you don't have access issue"?

N
nbanburyBMWAuthor
October 28, 2022

Morning. Sorry for the slow reply. No changes made at all to anything to do with my account. The solution marked as "correct answer" isn't the answer as I am nowhere near those API limitations.

Is there anyone I can talk to who could maybe troubleshoot this?

Jennifer_Dungan
Community Advisor and Adobe Champion
Jennifer_DunganCommunity Advisor and Adobe ChampionAccepted solution
Community Advisor and Adobe Champion
October 28, 2022

Yeah, I was thinking that wasn't the case.. let me reach out to some of my Adobe contacts and see if we can get you fixed up.

 

In the meantime, can you log out of the Report Builder plugin, restart Excel, then re-login, and make sure that it connects to your organization login (hopefully it prompts you). Just to make sure it's not a weird account thing?

Terms & ConditionsAccessibility statement

Loading footer...