Missing data in Power Query Editor

[totamum]

I know this is PowerBi but I needed help with Power Query and couldn't see where to post. 

When I import a csv, some rows are missing in Power Query Editor.  I understand it limits how many you can see but when I merge the query with another query and load in Excel it is still missing.  However, when I tried importing the csv and load it in Excel, I see the missing rows.  It just seems to be Power Query and there are a few rows, they are random and not at the bottom of the file so I don't think they're cut off.  Any idea what might be happening here?

Thanks

[v-hjannapu]

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.

[totamum]

Thank you for your reply @v-hjannapu @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.  

[v-hjannapu]

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 · Accepted solution]

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 @v-hjannapu and @Omid_Motamedise @AmiraBedh 

[Omid_Motamedise]

Hi @totamum 

What kind of merge did you apply? Make sure you have used left outer Join.

[AmiraBedh]

Hello !

Can you please provide the Power Query code and some data ?

[totamum]

Thank you, the query is = Table.TransformColumnTypes(#"Promoted Headers",{{"Month", type date}, {"Ticker", type text}, {"Article", type text}, {"Type", type text}, {"Name", type text}, {"Company Name", type text}, {"Page Views", Int64.Type}, {"Downloads", Int64.Type}})

What kind of data do you mean, a sample?