Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

calculated tables do not update

I have a calculated table that uses most recent data to calculate a metric. This worked previously, but now when I refresh my data connection, the calculated table does not update.   For example. I...
Need Help
HouseOfMax's avatar
HouseOfMax
Frequent Visitor
6 years ago

I have the same issue, but only for some of my calculated tables.

I have a data model that used both direct queries and imported tables, and the calculated tables that use imported data seem to update when the source is manually refreshed, however, the calculated tables that have direct queries as their source don't update when the source is automatically updated.

Merged tables (from imports) don't automatically update when the originals are updated either, they need to be manually refreshed.

Are these issues related to using a composite model, or am I doing something wrong? And is there a way around it?

Thanks!

  • d_gosbell's avatar
    d_gosbell
    Super User
    6 years ago
    HouseOfMax wrote:

    however, the calculated tables that have direct queries as their source don't update when the source is automatically updated.

    This is just how calculated tables work. They are stored in-memory (like imported tables) and are only updated when you do a refresh operation. If you need realtime data do not use calculated tables, you would have to look at some other option like doing a view in your source database.