About Consistency Among Data in Multiple Table Sources

It's important to confirm that your table sources' data is consistent.

For example, the year-level logical table source and the month-level logical table source for your time dimension should cover the same time period.

You might see consistency issues in table source data for queries that override null suppression. For example, some aggregate tables might not include the dimension records that correspond to the null fact values such as a yearly sales aggregate table that doesn't include years with no sales. All years in the year dimension must exist for the null values to be included in the result.