Forum Discussion

helgerg's avatar
helgerg
Frequent Visitor
8 years ago
Solved

We cannot convert the value null to type Logical in Service

I have a report reading from Azure SQL and Data Lake Store. When updating in Power BI Desktop it works fine, but in Service it says "We cannot convert the value null to type Logical" and then only t...
Need Help
  • CasperLehmann's avatar
    CasperLehmann
    8 years ago

    When you use the Azure Data Lake connector Power BI creates your query for you. The resulting query, running through DataLake.Contents is then supplied with default parameters that (at the time of writing) break the evaluation once uploaded to the Power BI service. The problem is the second param, the empty record []. Exchange it for a null, or simply delete it.

     

    Bad:

    DataLake.Contents("adl://adlstest01.azuredatalakestore.net/data/examples/entries.csv", [])

     

    Good:

    DataLake.Contents("adl://adlstest01.azuredatalakestore.net/data/examples/entries.csv", null)

     

    At least this worked for me.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI helgerg,

 

I think it might be a issue with azure data lake service, I'd like to suggest you open a support ticket for this scenario to get more support from power bi team.

submit a support ticket

 

Regards,

Xiaoxin Sheng

CasperLehmann's avatar
CasperLehmann
Frequent Visitor
8 years ago

When you use the Azure Data Lake connector Power BI creates your query for you. The resulting query, running through DataLake.Contents is then supplied with default parameters that (at the time of writing) break the evaluation once uploaded to the Power BI service. The problem is the second param, the empty record []. Exchange it for a null, or simply delete it.

 

Bad:

DataLake.Contents("adl://adlstest01.azuredatalakestore.net/data/examples/entries.csv", [])

 

Good:

DataLake.Contents("adl://adlstest01.azuredatalakestore.net/data/examples/entries.csv", null)

 

At least this worked for me.

  • helgerg's avatar
    helgerg
    Frequent Visitor
    8 years ago

    thanks, it did the trick :) 

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

     

    In VS, I am not able to open a blank query to write this correct version of the connection string, as far as I am aware.