Forum Discussion
Direct Query not refreshing when used within Union
- 5 years ago
kenneth_hess , Have set up refresh for this table? - Please refer to Microsoft doc -
Calculated tables
You can add calculated tables to a model that uses DirectQuery. The Data Analysis Expressions (DAX) that define the calculated table can reference either imported or DirectQuery tables or a combination of the two.
Calculated tables are always imported, and their data is refreshed when you refresh the tables. If a calculated table refers to a DirectQuery table, visuals that refer to the DirectQuery table always show the latest values in the underlying source. Alternatively, visuals that refer to the calculated table show the values at the time when the calculated table was last refreshed.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models
kenneth_hess , Have set up refresh for this table? - Please refer to Microsoft doc -
Calculated tables
You can add calculated tables to a model that uses DirectQuery. The Data Analysis Expressions (DAX) that define the calculated table can reference either imported or DirectQuery tables or a combination of the two.
Calculated tables are always imported, and their data is refreshed when you refresh the tables. If a calculated table refers to a DirectQuery table, visuals that refer to the DirectQuery table always show the latest values in the underlying source. Alternatively, visuals that refer to the calculated table show the values at the time when the calculated table was last refreshed.
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models