Forum Discussion
Helper IMissing data in Power Query Editor
Thank you. I've worked out the issue. First of all, the filter search is case sensitive so I was filtering by Text>Equals using lowercase letters but what I was filtering was all uppercase. The other issue is that the data I was joining the two queries by had a small variation in their values, one had punctuation and one didn't. I didn't suspect this as they both should have been the same coming from the same source. So all sorted. Thanks for replying Anonymous and Omid_Motamedise AmiraBedh
Helper IThank you for your reply Anonymous Omid_Motamedise AmiraBedh The thing is, the data doesn't even load in the Power Query Edit screen. It is there in the file but when I load the file in Power Query (Get Data > File > Load) it then isn't there in the Power Query Edit screen.
Hi totamum,
Thanks for the update.
Since the rows are missing right when you load the CSV into Power Query before merge, this usually happens if Power Query is not reading the file correctly. Please check if the delimiter is set properly ( sometimes it may be ; or tab instead of , ). In some cases, extra characters or line breaks in the CSV can also cause rows to be skipped, so it’s good to open the file in Notepad or Excel once and check those rows. If you can share a small sample file including one of the missing rows, it will be easier to reproduce and confirm the exact reason.
Best regards,
Community Support Team.
- totamum
Thank you. I've worked out the issue. First of all, the filter search is case sensitive so I was filtering by Text>Equals using lowercase letters but what I was filtering was all uppercase. The other issue is that the data I was joining the two queries by had a small variation in their values, one had punctuation and one didn't. I didn't suspect this as they both should have been the same coming from the same source. So all sorted. Thanks for replying Anonymous and Omid_Motamedise AmiraBedh