Issue with "ISERROR"

[SwaroopRoyM]

Hi Team,

It seems there's an issue with "ISERROR" function. When we're using this it's giving error in Power BI desktop version. Still if you goahead and publish this on Power BI service, it's working fine without any issues.

Could someone please check and let me know the details?

Thanks,

Swaroop

[v-haibl-msft]

@SwaroopRoyM

Could you please provide some sample data and your DAX expression to repro this issue? I tried on my side but cannot repro in PBI Desktop.

Best Regards,
Herbert

[SwaroopRoyM]

Hi, I'm not able to attach/paste the image of the error am getting. Hence writing the error below: Couldn't load the data for this visual MdxScript(Model)(1,78) function 'ISERROR' is not supported in DirectQuery Mode Thanks, Swaroop

[SwaroopRoyM]

Any solutions for my problem? Thanks, Swaroop

[v-haibl-msft]

@SwaroopRoyM

Please try to enable following option in Power BI Desktop to see if it works.

Best Regards,
Herbert

[SwaroopRoyM]

Hi Herbert,

Could you please let me know from where i can see these options, i tried to figure it out but couldn't on the Power BI desktop?

Thanks,

Swaroop

[SwaroopRoyM]

Hi Herbert,

Could you please let me know if you have any updates on my question?

Thanks for all your help.

Regards,

Swaroop

[v-haibl-msft]

@SwaroopRoyM

Please refer to the following gif.

Best Regards,
Herbert