Calculated Column throws error when Schedule refresh is set up on Power Bi Service

[HR_BI]

Hello Everyone,

I have problem related to Power BI Service. I have created a dataset(combination of direct query and import model) and the dataset has calculated columns. This dataset works completely fine is Power BI desktop as well as when published in Power BI service(no schedule refresh set up). However, once the schedule refresh is set up, the calculated columns starts to throw this error "The query referenced calculated column .....ABC column....which does not hold any data because evaluation of one of the rows caused an error "

Please find more detailed description of my dataset below:

The calculated column Test 3 works fine which has coulmn coming from import table however the Test 1 throws error(The query referenced calculated column Test 1 which does not hold any data because evaluation of one of the rows caused an error) which has column coming from shared dataset.

Any help is greatly appreciated!

[HR_BI]

DAX calculated columns.

[otravers]

Could you create the same column in PQ instead? It would give you an easy way to identify the offending row.

[HR_BI]

In my scenario I can't use PQ. The use case I have can only be solved using calculated columns. And the no rows have any error. It works completely fine in Power BI Desktop.

[otravers]

Can you try using an IFERROR condition in the DAX statement defining your calculated column? Have it spit out a ludicrous value that you can easily seek in the service so find the rows that lead to the error.

[otravers]

Just to be clear, are these Power Query or DAX calculated columns?