Query Caching Disappeared

vitoriamariabr · ‎11-27-2024

Hello!
I am facing an automatic update problem in PowerBI services.
I have the free trial of Fabric and until then my reports updated normally by consulting the query cache. However, it's been a week since the updates no longer consult the query cache, and I couldn't understand why, since it is enabled and the license is ok. Can you help me?

update until the 21st:

update later:

Anonymous · ‎11-27-2024

Hi @vitoriamariabr ,

The data and query cache phases are independent of each other but run in sequence. The data refresh run first, and when that succeeds, the query cache refresh runs (You could check out the first image you posted).

From the second image, it shows us the data refresh failed, so query refresh will not be initiated.

Please always ensure that basic requirements for refresh are met and verified:

Verify the gateway version is up to date.
Verify the report has a gateway selected. If there's no gateway selected, the data source might have changed or might be missing.
Verify all data sources in report are configured with correct gateway.

If the report has two or more different sources, we recommend troubleshooting the following:

Connect from PBI Desktop to one source at a time.
Publish the report and see if the refresh in PBI Service works.
Chekc each source separately.

You could select the Mostrar link beside a failure to get more information about the failed refresh attempt, which help us with troubleshotting the issue.

Best regards,

Lucy Chen

If the post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vitoriamariabr · ‎11-28-2024

Thanks for the answer! I tested the update with two other accounts and they worked, it is specifically with this account that the cache stopped working.