Error: The column cannot be pushed to the remote data source and cannot be used in this scenario

[sandy_liew]

Hi all, by referring to the above matter, I need help in order to resolve the error shown:

I have created a calculated column by using the DAX formula as shown in the following:

Delta = 'A-Output by Spec'[Output by Spec Output Die Quantity]-'Metric_Total DRR(Weekly)'[DRR1]

After that, the error message: "The column 'A-Output by Spec'[Delta] cannot be pushed to the remote data source and cannot be used in this scenario." is occuring.

I would like to know what does it mean with the above error and is there any way I could resolve it?

[hackcrr · Accepted solution]

Hi, @sandy_liew 

The error message you are encountering typically occurs when you try to use a calculated column or a measure in Power BI that cannot be pushed to the data source when you're using DirectQuery mode. In DirectQuery mode, certain calculations (like calculated columns or measures) cannot be processed locally within Power BI; they need to be pushed to the underlying data source (such as SQL Server, etc.). If the operation cannot be translated into a query that the underlying data source can handle, Power BI throws this error.

If feasible, switch your report from DirectQuery to Import Mode. This will allow Power BI to compute the calculated column locally within the Power BI engine, without relying on the data source to handle the calculation.

Instead of creating a calculated column, you can try to rewrite the formula as a measure. Measures are calculated on the fly and are typically more flexible in DirectQuery mode.

Delta Measure = SUM('A-Output by Spec'[Output by Spec Output Die Quantity]) - SUM('Metric_Total DRR(Weekly)'[DRR1])

[AntrikshSharma]

@sandy_liew Are those two column references or measures? If columns then you can't create a Calculated column that references columns from other tables without some DAX Function.

[speedramps]

Does your data source nor support calculated columns?

Is the data model a combination of direct query and import mode, live conection or Fabric direct lake ? They dont support calculated columns?.

Try the same caculated column with just a import mode, it should work and provde the problem is the data source.

Please click [accept solution] and the the thumbs up button.

As the very least please click the thumbs up to acknowledge the helpful idea. Thank you.