Datalaod

[sdhn]

Hi All,

I have multipel excel files in the share point.

I uploaded throug sharepoint folder features.

Seems like values of one column at least not fully loaded.

There are following values in the particular column

YES

NO

ASSESSESD 
NOT ASSESSED

BLANK

YES valuses are showing as a null. 

Please advise how to check dataload succesuly loaded.

Help will be appreciated. 

Thanks

[amitchandak]

@sdhn , there should not be an error folder or red line under column name in power query

Second, you might have a return character before Yes, use the clean option in power query to check that

Power Query Trim and Clean : https://youtu.be/NRYPsCnS0w4