Scheduled dataset refresh failed

[1_2]

There was an error when processing the data in the dataset.Hide details
{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"We cannot convert the value null to type Logical."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}}],"exceptionCulprit":1}}} Table: production.

Please help it's urgent

[v-easonf-msft]

Hi,  @1_2 

As mentioned by @arvindsingh802 ,This kind of error is usually caused by the conversion of a null value. You need to recheck the query in the original pbix file.
If there is a null value, it is recommended to add a filter step at the end of you current step to remove empty.

Best Regards,
Community Support Team _ Eason

[arvindsingh802]

As error explains there are null values in a column of your Table: production, which you chnaged type as logical, eighter remove of fill some value for null as per your business logic and this issue will be resolved.

If this post helps, then please consider Accept it as the solution and give it a thumbs up