Forum Discussion

HR_BI's avatar
HR_BI
Frequent Visitor
4 years ago

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

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!

Need Help

5 Replies

  • otravers's avatar
    otravers
    Community Champion
    4 years ago

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

    • otravers's avatar
      otravers
      Community Champion
      4 years ago

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

      • HR_BI's avatar
        HR_BI
        Frequent Visitor
        4 years ago

        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.