Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to Solution.
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
Thank you! Same issue here and this solved it
This work around did the job for me too.
Thanks
Some bug here. Hope it will be corrected soon.
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
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.