Forum Discussion

denis163's avatar
denis163
Frequent Visitor
3 years ago
Solved

Dataflow Refresh Failure - cannot convert the value null to type Logical

Hello all! I have a dataflow in PBI Service which contains 5 tables. Data source for all of them is a SQL server.  It worked well and refreshes were completed without any problems. But recent...
Dataflow
Need Help
  • cassidy's avatar
    cassidy
    3 years ago

    I can't help you find the error, but power query is working off a sample of the data and can sometimes show everything is valid until the refresh (when it actually processes it all).

    Type Logical is expecting "True" or "False" and it received Null, so look for anywhere in your chain of processing that would occur.

    Change in credentials should not be related, but rather a coincidence.

cassidy's avatar
cassidy
Power Participant
3 years ago

I can't help you find the error, but power query is working off a sample of the data and can sometimes show everything is valid until the refresh (when it actually processes it all).

Type Logical is expecting "True" or "False" and it received Null, so look for anywhere in your chain of processing that would occur.

Change in credentials should not be related, but rather a coincidence.