Forum Discussion
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.
1 Reply
- amitchandakSuper User
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