Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
brika
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
v-yuezhe-msft
Employee
Employee

@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
mspreng
Frequent Visitor

Thank you! Same issue here and this solved it

Anonymous
Not applicable

This work around did the job for me too.

 

Thanks

Anonymous
Not applicable

Some bug here. Hope it will be corrected soon.

v-yuezhe-msft
Employee
Employee

@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.

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?

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

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors