Forum Discussion
When i remove file from folder , i get error msg
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 ...
Hi Anonymous
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
Anonymous -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.