scheduled refresh fail with "cannot convert the value null to type Logical" error

[candycane1219]

I've been trying to setup automatic refresh w/o luck. Received failure "We cannot convert the value null to type Logical. Table: <table name>" Here's more details-

Activity Id: 713641c6-eb1d-4fe5-9561-ce9a1a64cef2

Request Id: 3a315d8a-8cc8-4049-a9b7-cf0abc37dc97

Cluster Name: DF-MSIT-SCUS-redirect.analysis.windows.net

Refresh Start Time: January 29, 2019 15:03 UTC

Refresh End Time: January 29, 2019 15:13 UTC

My dataset is using DataLake.Contents("adl//.../datasource.csv"). Any suggestions? Thanks.

[Greg_Deckler]

Sounds like you need to add a step to your Query before your Change Type to filter out null values from some column or change the null (Replace Values) to true/false.