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

[brika]

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?

[mspreng]

Thank you! Same issue here and this solved it

[Anonymous]

This work around did the job for me too.

Thanks

[Anonymous]

Some bug here. Hope it will be corrected soon.

[Anonymous · Accepted solution]

@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

[JulianPayne_i4]

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?

[kanungo_sagar]

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

[brika]

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.