Forum Discussion
Table calcuated with Dax not refreshing when source table updates
Hi, PowerBI-ELM
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.
For reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-tables
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more.
Hi, PowerBI-ELM
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.
For reference:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-calculated-tables
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more.