Forum Discussion

brika's avatar
brika
Frequent Visitor
8 years ago
Solved

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 get...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
JulianPayne_i4
Frequent Visitor
7 years ago

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?