Forum Discussion
scheduled refresh fail with "cannot convert the value null to type Logical" error
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.
1 Reply
- Greg_Deckler
Community Champion
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.
