Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
denis163
Frequent Visitor

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. 

denis163_0-1680241379421.png

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:

denis163_1-1680243412474.png

denis163_2-1680243586254.png

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

1 ACCEPTED SOLUTION
cassidy
Power Participant
Power Participant

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.

View solution in original post

1 REPLY 1
cassidy
Power Participant
Power Participant

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors