Forum Discussion

1_2's avatar
1_2
Regular Visitor
5 years ago

Scheduled dataset refresh failed

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

Need Help

2 Replies

  • arvindsingh802's avatar
    arvindsingh802
    Icon for Community Champion rankCommunity Champion
    5 years ago

    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

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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