Forum Discussion
We cannot convert the value null to type Logical in Service
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.
Hi helgerg,
Maybe you can try to use iferror to handling error records and replace them as 'No' result.
Regards,
Xiaoxin Sheng
I have now tried to remove all computed columns, all measures, and all type conversions or other steps in the query. It still fails...
It works if I remove the data lake table...
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
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.
thanks, it did the trick :)