Forum Discussion
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 comp...
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.
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.