Deleted Aggregate Measurements still have tables in AxDW

(3) Share

Report

Posted on by FV-13050815-0

We have deleted a few unused old Aggregate Measurements from the AOT, with the aim to free up the DB space used by them.
Unfortunately the deletion of these measurements has not triggered the deletion of the correspondent tables in the AxDW database - we can see this from the F&O capacity in Power Platform admin center - and we have no idea if there is a functionality in F&O that does a full refresh/rebuild of the AxDW entities/measurements so that we can get rid of these tables.
Anyone that has faced and solved this issue

All responses (2)

Answers (0)

FV-13050815-0 9 on at

Like (0)

Report

Deleted Aggregate Measurements still have tables in AxDW

Thank you for your help, unfortunately "Full reset" is running but only refreshes the enabled (existing) entities, has not deleted the tables for delete entities.
Andreas Raithel 4,890 Super User 2025 Season 1 on at

Like (0)

Report

Deleted Aggregate Measurements still have tables in AxDW

Hy,

I don't know how AxDW data are truncated or deleted, but for refreshing the AxDW there is batch "Full reset" typically runs every view minutes.

The batch picks up the Entities that are defined to refresh in the Entity Store /System Administration/Setup/.

The batch refreshes the entities accordingly to the time interval that is specified in the Entity Store.

So the batch starts every e.g. 5 min, but refeshes only what has to be refreshed based on the last refresh time and the configured interval.

Hope this helps.