Forum Discussion
Problem with updating the Power BI Report Server dashboard
It turned out to be much simpler. Friends, it turns out that updating data in SQL Server takes longer, and the dashboard simply connects when the data in the final table is not yet ready. Therefore, it is empty. The issue has been resolved.
Hi ReyCarter_777 ,
The issue you're experiencing is related to how Power BI Report Server manages report execution and caching, rather than the data refresh itself. When a dataset is refreshed, it updates the underlying data, but users may still see a cached or previously rendered version of the report, which can appear empty even though the data exists in the database.
Since users access the report directly from the server, using URL parameters is not an effective solution. Instead, it is advisable to adjust the report’s execution settings in the Report Server portal to ensure it always retrieves the latest data. Review the processing or execution properties and configure the report to run with the most recent data, avoiding cached copies or snapshots.
If caching is enabled, consider disabling it or synchronizing its expiration with your data refresh schedule to prevent outdated results. After updating these settings, clear any existing cached instances, as an empty version may already be stored. Once the execution settings and cache are updated, the report should display current data for all users without requiring manual intervention.
Thank you.
Thanks for the detailed response. Can you tell me where the cache management settings are located in Report Server? I couldn't find them in Configuration Manager.
Hi ReyCarter_777 ,
The cache and execution settings are not available in Configuration Manager; they are managed through the Power BI Report Server web portal. To adjust these settings, open the report in the portal, select Manage from the three dots menu, and review the Processing Options or Execution section.
Ensure the report is configured to run with the latest data, not from a cached version or snapshot. If caching is enabled, consider disabling it or clearing any cached instances, as this may address the issue you are experiencing.
Thank you.I don't have such items in Report Server. Can you send me a screenshot?