PowerBi Service - We cannot convert the value null to type Logical.

[Swap]

While using ADLS as data source in PowerBI report and scheduling it throws an error - We cannot convert the value null to type Logical. Same report refresh work fine using powerbi desktop.

[Parkavi]

Hi,

We are also facing the same issue while refreshing the dataset in Service.

We tried with csv, tsv, xls files from ADLS to PowerBI. 

Throws the same error. "We cannot convert the value null to type Logical".

Please, Someone can explain how to resolve this issue and why this is happening.

Regards,

Parkavi

[v-yuezhe-msft]

@Swap @Parkavi,

This is a known issue. Please remove the [] from the DataLake.Contents command in the Advanecd Editor of your query.

Example: 

Original code:

let

    Source = DataLake.Contents("URL", [])

in

    Source

Changed code:

let

    Source = DataLake.Contents("URL")

in

    Source

Regards,
Lydia

[Parkavi]

Thank you Lydia. It is working fine now.

Regards,

Parkavi P