Forum Discussion

kenneth_hess's avatar
kenneth_hess
Regular Visitor
5 years ago
Solved

Direct Query not refreshing when used within Union

We have two data sources setup in PBI.  One source is imported directly into PBI for historical data.  Another data source is using a direct query to get results from SQL (via on premise gateway) for...
  • amitchandak's avatar
    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