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

[jdubs]

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. 

[amitchandak]

@jdubs , check if there is an error in that table.  Sometimes it shows an error on the left as a table. Or check while data is getting loaded.

refer if needed

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs