Learn how to refresh your reports in Power BI when your data is out of date.

Identifying Stale Reports

This article helps you identify whether your Cognition 360 reports in Power BI have been refreshed on schedule. If a Power BI report hasn't been accessed for over 30 days, Microsoft may stop updating it, resulting in stale data. You can still access the report, but you may notice that the information is outdated. Cognition 360 continues uploading data to Power BI, so you can refresh your reports to load current data.

Below, you'll find how to identify and ways to refresh stale reports.

Steps to Check for Stale Schedules

1. Check the Refresh Schedule:
   • Look at the Next Refresh column for each report.
   • If it shows N/A, the report's schedule is stale.
     
2. Understand Refresh Types:
   • Reports included in an app have an automatic refresh schedule. If this is disabled, you'll need to re-enable it.
   • Reports not included in an app must be refreshed manually when needed.

Refreshing Your Reports

There are two methods to refresh your reports or re-enable a scheduled refresh.

Method 1: Quick Refresh

• Use the Refresh Icon:

  • Click the refresh icon (red highlighted button) in the toolbar to instantly refresh the report.

    

  • This action also re-enables any stale automatic refresh schedule.

Method 2: Adjust the Refresh Schedule

1. Open Schedule Refresh Settings:
   • Click on the Schedule Refresh option (red highlighted button) or the ellipsis (…) next to the report and select Settings.
     
2. Update the Schedule:
   • Update the Time zone.
   • Toggle the refresh switch off and on again to force the settings to save.
   • Update the refresh frequency and set a time. (we recommend between 6 am and 7:30 am to ensure processing completes before the refresh happens)
   • Click Apply to save your changes.
     

Refresh from Within a Report

• Refresh Visuals:
  • Use the refresh option in the report to update visuals with the latest information from the semantic model (this does not refresh the semantic model).
  • If the data hasn’t been refreshed, visuals will still show outdated information.
     
• Check Last Refresh:
  • If unsure when the data was last updated, click on the dropdown next to the report name at the top left.
    

By following these steps, you can ensure your Power BI reports are always up to date with the latest data. If issues continue please submit in a ticket to our support team.