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

denis163 — Fri, 31 Mar 2023 06:42:22 GMT

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 recently after taking over this dataflow to different owner (credentials were filled), we have an issue with refreshes:

2023-03-31 08:42:09,CAPA,Failed,capa_primp_bridge,FullRefreshPolicyPartition,Completed,2023-03-31 08:42:09,2023-03-31 08:42:45,00:00:35.9690,1654,77,3668244,00:00:03.9060,00:00:00.1030,Cached,NA

2023-03-31 08:42:45,CAPA,Failed,primp_short_reference,FullRefreshPolicyPartition,Completed,2023-03-31 08:42:45,2023-03-31 08:49:05,00:06:20.3730,1619,2080,140396,00:00:42.1410,00:00:00.0520,Cached + folded,NA

2023-03-31 08:49:06,CAPA,Failed,capa_phase_tracking,NA,Failed,2023-03-31 08:49:06,2023-03-31 08:52:48,00:03:41.9370,NA,NA,NA,NA,NA,NA,Error: Expression.Error: We cannot convert the value null to type Logical. . RootActivityId = 7ff74b17-2204-445e-a3d2-bccf1a7be019.Param1 = Expression.Error: We cannot convert the value null to type Logical. Request ID: e577c00d-33e9-b297-91e9-e28de43233dc.

2023-03-31 08:49:06,CAPA,Failed,capa_id_number_bridge,FullRefreshPolicyPartition,Completed,2023-03-31 08:49:06,2023-03-31 08:52:26,00:03:20.2480,3142,55,2640192,00:01:03.4690,00:00:00.0670,Cached + folded,NA

2023-03-31 08:52:48,CAPA,Failed,report capa_dashboard,NA,Failed,2023-03-31 08:52:48,2023-03-31 08:52:48,00:00:00.0000,NA,NA,NA,NA,NA,NA,Error: One or more upstream operations failed.. Request ID: e577c00d-33e9-b297-91e9-e28de43233dc.

If I get it right the main reason is in the table capa_phase_tracking, so I dived into it to see query steps and find an issue. But it seems like all query steps work fine and show me final result without any problems:

And now I'm struggling to identify the problem step, because while dataflow is refreshing I have a failure - but inside power query it works well.

is it possible to recognize a problematic step by the error description? I would appreciate any advice

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

cassidy — Fri, 31 Mar 2023 21:14:42 GMT

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.

topic Re: Dataflow Refresh Failure - cannot convert the value null to type Logical in Service

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

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