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.

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 :)