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

  • kanungo_sagar's avatar
    kanungo_sagar
    Regular Visitor
    7 years ago

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

    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.

  • 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?