cancel
Showing results for 
Search instead for 
Did you mean: 

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

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.

Status: Accepted
Comments
Visitor

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

Moderator

@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

Visitor

Thank you Lydia. It is working fine now.

 

Regards,

Parkavi P

 

 

Established Member
Status changed to: Accepted