Forum Discussion
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?
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
7 Replies
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,
LydiaThanks 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.
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?
Thank you! Same issue here and this solved it
