PowerBi report not updating for the newest date added

[TVoS]

I have a report I manage which gets updated each week with new inputs. When updating with my latest weekly update, the data has appeared like normal in the data query and in the table view, but for some reason it will not show up in the report view. I have looked thorugh all of the filters, and they are as they should be, and when I also remake some of the tables in a new tab, the data for the newest date shows up fine, however I need the existing reports to be updated. How could I resolve this?

[danextian]

Hi @TVoS 

If the data is updated in the table view but now in the report view, reasons I can think of:

• there are filters coming from a separate table which is either from the filter pane or from slicers
• hidden slicers. For example a dates table that is not updated or doesn't contain the new dates.
• filters in the measures themselves.

[Ritaf1983 · Accepted solution]

Hi @TVoS 

To address the issue where the newest data does not appear in the report view despite being visible in the data query and table view, follow these troubleshooting steps:

Step 1: Verify Data Source and Refresh
Confirm Data Source:

Ensure the data source has been refreshed successfully.
Check if any connection or update issues occurred during the refresh.
Clear and Refresh Cache:

Sometimes, Power BI caches old data. Clear the cache and refresh the dataset:
File > Options and Settings > Options > Data Load > Clear Cache.
Step 2: Check Filters and Slicers
Validate Filters in Report View:

Double-check all filters (page-level, visual-level, and report-level filters).
Remove all filters temporarily to confirm whether the new data appears.
Inspect Slicers:

Ensure that slicers include the latest data. Adjust slicer settings to include "All" or the specific date range covering the new inputs.
Step 3: Validate Relationships
Check Data Model Relationships:

Confirm that all relationships between tables are correct and active.
Ensure the data from the new week is properly related to other tables.
"Inactive Relationships" Issue:

If the relationship is inactive, activate it or revise your DAX calculations to use USERELATIONSHIP().
Step 4: Recalculate DAX Measures
Review Existing Measures:

Check if any DAX measures use a fixed time period or filter that excludes the new data.
Update DAX expressions to handle dynamic time periods or data.
Test with Simple Visualizations:

Create a simple table or card visual in the same report view to ensure the measures work correctly for the new data.
Step 5: Check Report Layout and Sync Issues
Hidden Visuals or Layers:

Ensure visuals are not hidden or layered incorrectly, preventing new data from being visible.
Rebuild Visuals If Necessary:

If all else fails, try recreating the problematic visuals. This can help resolve visual-specific bugs.
Step 6: Validate Data Refresh Settings
Review Incremental Refresh (if enabled):

If using incremental refresh, check whether the new week’s data falls within the refresh policy range.
Test with Full Refresh:

Temporarily disable incremental refresh and perform a full dataset refresh to see if the issue resolves.
Step 7: Verify Data Source Updates
Confirm Source Data Integrity:

Check the source system or file to ensure all data is present and correctly formatted.
Review Data Query Transformations:

Inspect Power Query steps for filtering or transformations that might exclude the latest data.
Step 8: Verify Published Reports
Check Power BI Service:
If using the Power BI Service, confirm that the published report has been updated after the dataset refresh.
Re-publish the report from Power BI Desktop if necessary.
Additional Notes:
Understanding the data source is crucial for resolving the issue effectively. Common sources like Excel, SQL, or APIs may have specific quirks affecting how new data is pulled and displayed.

For More information about refresh troubleshooting :

https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios

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

[TVoS]

Went down the list trying each option, and found a hidden slicer that was messing up the dates selected, removed it, and everythings working as it should be. Thanks for the help