Forum Discussion

jdubs's avatar
jdubs
Helper V
3 years ago

Null values in column where there should be data (SQL)

Well this is a new one.

 

All of a sudden values in a column are all showing null when there should be data. If I look at the raw data from the Transform tab one of my columns from a SQL database shows all null values. If I take the same SELECT statement and paste it into a query in SQL I see the expected results. The target field is a basic Option Set field in a Dynamics 365 table. 

 

I just updated to the April '23 release and am seeing the same result.