Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
I have a stating dataflow A and a transformation dataflow B, where B refers to tables in A. When I refresh the flow A, it will also refresh B. Since yesterday, this chained refresh startred to fail during the refresh of B. In the error file, I could see something like below:
Error: Expression.Error: We cannot convert the value null to type Logical. . RootActivityId = <GUID>.Param1 = Expression.Error: We cannot convert the value null to type Logical. Request ID: <GUID>.
However, If I refresh the dataflow B independent of A, it finishes without any errros. Also, If I dispable the "Enable Load" options for the tables in B that are linked from A (this way the chained refresh between A and B will be disabled), and then refresh A anb B individually, both refreshes finish just fine.
So apparently "value null type Logical" has nothing to do with this error. Why does this happen and how can I enable chained refresh without causing such errors?
I meant staging dataflow A 😞
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.