missing data

1) Incremental Refresh 

If the dataset uses Incremental Refresh, Power BI will only load recent years by design.

Typical setup:

• Store historical data in SQL (5+ years)

• Power BI model configured to keep only:

  • last 1–2 years in the dataset

  • older data is not imported

How to check

In Power BI Desktop:

1. Go to Transform data

2. Select the fact table

3. Check if it’s filtered using parameters like:

   • RangeStart

   • RangeEnd

If yes → Power BI is intentionally loading only recent data.

2) Date table filtering

Your Calendar / Date dimension may only cover 2025–2026.

If visuals are using the Date table (most do), any fact data outside that range is silently excluded.

How to check

• Open your Date table

• Verify the earliest and latest dates

• Check for filters like:

   

  CALENDAR ( DATE(2025,1,1), DATE(2026,12,31) )

3) Hidden filters (report / page / visual)

Filters can exist even if you didn’t explicitly add them.

Check:

• Visual-level filters

• Page-level filters

• Report-level filters

• Slicers (especially date slicers)

Look specifically for:

• “Last 1 year”

• “After 2024”

• Relative date filters

4) SQL view or query already filters the data

Even if the base table has 5 years, Power BI might be using:

• a SQL View

• a custom SQL query

• a stored procedure

that includes something like:

WHERE Date >= '2025-01-01'