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

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.