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.
I notice the same thing if I create a new table in the Query Editory based on the simpler table that I am refreshing incrementally. I do the pivot in the second table. What I find is that the new data added to first table (when published) does not flow down into the second table.
I figured that would work too.