Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Zahid Shaikh]

Hi 

 

I have few dataflows (on shared capacity) which has a scheduled refresh and refresh fails for below listed error messages

 

Error: Expression.Error: We cannot convert the value null to type Logical

Error: DataFormat.Error: We couldn’t convert to Number

 

I have a lengthy dataflow with 60 lines of (applied steps) performing  required transformation or cleansing on data, It gets really difficult to go through each step in PBI Service to find the cause of the error, and I have checked this it do not show any error over there, yet at the time of (on demand or scheduled refresh) the data flow fails with 2 error messages above (shown in RED) 

 

Is there an elegant way to Exception handle known errors (so that my refresh do not fail) or what I can do to add additional M code so that it remains full proof and safe from above shown errors and goes through a successful refresh.

Thanks in Advance

——————————
Zahid
Power BI Developer
——————————

[Marc Schroyen]

Hi Zahid,

Try otherwise can help.
https://docs.microsoft.com/en-us/power-query/handlingerrors

——————————
Marc Schroyen
Liège Belgium
——————————
——————————————-