Forum Discussion

sdhn's avatar
sdhn
Responsive Resident
4 years ago

Datalaod

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

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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