Forum Discussion
User-defined aggregations and outdated data in the import table
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
1 Reply
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."
