cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brika Frequent Visitor
Frequent Visitor

Cannot get data from Data Lake due to error "We cannot convert the value null to type Logical."

I have the latest Power BI desktop and I'm trying to connect to a Data Lake store for the first time. I've entered the URL for adl://<myData>.azuredatalakestore.net/ and when I try to connect, it gets:

 

Details: "We cannot convert the value null to type Logical."

 

It is not even connecting to a file yet and so there are no query steps to edit yet. Any ideas on what the issue might be?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Cannot get data from Data Lake due to error "We cannot convert the value null to type Logic

@brika,

In Power BI Desktop, open a new blank query and enter the following code in Advanced Editor to work around this issue.


let

    Source = DataLake.Contents("URL")

in

    Source


Also, I have reported this issue internally. Will post back once I get any updates.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Cannot get data from Data Lake due to error "We cannot convert the value null to type Logic

@brika,

In Power BI Desktop, open a new blank query and enter the following code in Advanced Editor to work around this issue.


let

    Source = DataLake.Contents("URL")

in

    Source


Also, I have reported this issue internally. Will post back once I get any updates.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

brika Frequent Visitor
Frequent Visitor

Re: Cannot get data from Data Lake due to error "We cannot convert the value null to type Logic

Thanks Lydia. That workaround did the trick. Thanks for reporting internally as well, this does seem to be a bug in ADL or Power BI for not allowing the other option to work.

sgiovinetti Frequent Visitor
Frequent Visitor

Re: Cannot get data from Data Lake due to error "We cannot convert the value null to type Logic

Some bug here. Hope it will be corrected soon.

mspreng Frequent Visitor
Frequent Visitor

Re: Cannot get data from Data Lake due to error "We cannot convert the value null to type Logic

Thank you! Same issue here and this solved it

Ceenuu Regular Visitor
Regular Visitor

Re: Cannot get data from Data Lake due to error "We cannot convert the value null to type Logic

This work around did the job for me too.

 

Thanks

kanungo_sagar Frequent Visitor
Frequent Visitor

Re: Cannot get data from Data Lake due to error "We cannot convert the value null to type Logic

Thanks for sharing this solution.(As I struggled to reach at blank query,I would like to highlight that blank query can be reached from (Get data -> Blank Query)

 

I also got another work around.

When I added some value like 1024 /100/500 in Page Size in Bytes (optional),it worked.

It seems like this is bug in Power BI.May be there is a code which is expecting some value in this field.

 

Regards,

Soubhagya

JulianPayne_i4 Frequent Visitor
Frequent Visitor

Re: Cannot get data from Data Lake due to error "We cannot convert the value null to type Logic

When trying to connect to AZDL with SSAS Azure in Visual Studio, I keep getting this error:

 

Details: "We cannot convert the value null to type Logical."

 

I do not get this error in Power BI using the same connection string.

 

connection string: adl://<mydata>.azuredatalakestore.net

 

Any thoughts?

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors
Top Kudoed Authors