Failed loading complete data

[SushmaReddy]

Hi Team,

     I developed a report using excel data which worked fine previously. When I changed the file which contains same columns is taking only 152 records and when the data is copied from new to old file it is working fine(loading complete records).Couldn't able to find the issue.Thanking you

Best Regards,

Sushma

[amitchandak · Accepted solution]

@SushmaReddy , Open the Power query, refresh, and check the issue. There might be error rows removed 

debug issue
https://www.youtube.com/watch?v=OE6DPmKqN7s


refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs