User-defined aggregations and outdated data in the import table

[jaaa186]

Hello

Unfortunately, I didn't have the opportunity to test user-defined aggregations, but after reading the documentation, I have one doubt.

After configuring user-defined aggregations, we usually end up with the following situation:

- a large table is in DQ mode

- dimension tables in Dual mode

- agg table in import mode
Now when we query agg table we get some aggregated values ​​from the imported table. I understand that these values ​​are current at the time of the last data refresh. This means that at the same time in a large table in DQ mode we have different data because data is stored there more or less in real time.
There may be differences in the these two tables- if the user for example wants to look at the lowest level of detail from the table in DQ mode, there may be values ​​that are not in the agg table - because the data has not been refreshed in the imported table.
Am I right or it works a bit different?

Regards

[DataInsights]

@jaaa186,

That's correct--a DirectQuery table may contain data that is not in the Import agg table. See the Microsoft article below:

https://learn.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced#keep-caches-in-sync 

"Aggregations that combine DirectQuery, Import, and/or Dual storage modes may return different data unless the in-memory cache is kept in sync with the source data."