cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Paulyeo11
Impactful Individual
Impactful Individual

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 test one file , once success then i add more file to test. Hope some one can share with me :-

Paulyeo11_0-1604443293876.png

 

1 ACCEPTED SOLUTION
PhilipTreacy
Super User III
Super User III

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

4 REPLIES 4
NikhilKumar
Super User II
Super User II

@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.


Nikhil
Hit the Thumbs-up button if you find this informative!!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!

Paulyeo11
Impactful Individual
Impactful Individual

Hi Sir

May i know how to remove below error ?

Paulyeo11_1-1604446877212.png

 

Paulyeo11_0-1604446844609.png

 

PhilipTreacy
Super User III
Super User III

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Paulyeo11
Impactful Individual
Impactful Individual

Hi Phil

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

Paul

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power BI User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.