Composite Model - Calculated Table Refreshing

[stecollis]

I'm looking to combine real time data with imported data. To do this I've created a composite model and then created a calculated table to merge the data. I have had to do this in order to ensure sumx calculations are calculated correctly. The real time data is brought in via direct query from an SQL database which contains counts. These counts need to be multiplied by an imported data set (it is an aggregated view that provides a cost). The counts need to be multipled by the costs to get the required result.

I have found that page refreshing this calculated table doesn't update due to the direct query data element and a manual data set refresh is required.

Does anyone know any way to get the above scenario to work? or is the page refresh functionality something to add as an idea?

[lbendlin]

Basically what you want is a user initiated refresh of an import mode data source (a calculated table is the same, technically).  This is not something that the Power BI design currently support, nor are they likely to support in the future as it has massive design implications.

What is your reason for insisting on a calculated table? Would a calculated column be sufficient (that is now supported even in direct query data sources)?

[stecollis]

I've attempted to use calculated columns however you don't seem to be able to use the related function which I'd need to store the value form the imported table. The error message that is returned is:

The column 'Prices_LoadedData[Price]' either doesn't exist or doesn't have a relationship to any table available in the current context.

From looking at other forum posts it seems this is a common issue with direct query.