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
Hello totamum,
Thank you for reaching out to the Microsoft fabric community forum.
I would also take a moment to thank Omid_Motamedise , AmiraBedh for actively participating in the community forum and for the solutions you have been sharing in the community forum. Your contributions make a real difference.
It doesn’t look like a row preview limit, but rather something in the merge step is filtering out those rows. A couple of things to check:
If you used Inner Join, only rows that match in both tables will show. Try Left Outer Join so that all rows from your main CSV will remain.
Also make sure the columns you are merging on are of the same data type for example both set to Text. If types are different, Power Query won’t match them and those rows will drop.
If possible, share a small sample of your CSV and the merge step then it will be easier to confirm exactly why those rows are missing.
Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-us/power-query/merge-queries-overview
Hope this helps if you have any queries we are happy to assist you further.
Best Regards,
Harshitha.
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