When i remove file from folder , i get error msg

[Paulyeo11]

Hi All

I am using folder load , i notice that when i remove some of file from folder during testing stage , i get loading error , it there a way to solve it ? As during testing stage i just want to test one file , once success then i add more file to test. Hope some one can share with me :-

[Anonymous]

@Paulyeo11 -If you are testing it, I think in your power query , you can do remove blank rows from Target table. 

As the error says it'snot allowed incase of many to many relationship.

OR, you can look for changing relationship criteria.

[Paulyeo11]

Hi Sir

May i know how to remove below error ?

[PhilipTreacy · Accepted solution]

Hi @Paulyeo11 

The error message tells you that in the date_t column some rows are empty and this is not allowed for the reasons stated in the error message.

Fix those errors in the source files - make sure you don't have any empty rows in date_t.

Phil

[Paulyeo11]

Hi Phil

This will save me a lot of time. Thank you.

Paul