I am pulling data from a simple, single table, odata feed that results in 84,869 rows in Power Query in PowerBI. I know the data source so I know this is the correct count. I also know that Power Query sees that many rows because when I run Transform > Count Rows its gives me the right answer. When I Close and Apply to get back to PowerBI the resulting table only has 84,863 rows, 6 lines missing. That's the count in the info at the bottom and when I make a simple reporting card and count the lines.
I originally spotted this issue using Power Query addin in Excel 2013, and moved to PowerBI to eliminate old software being the cause. The problem still occurs, with exactly the same missing numbers.
For context, the data I am using is Invoice data, an invoice has multiple lines.
I have identified some lines that went missing, they are 4 lines from a 13 line invoice. if I add an additional filter to my odata feed query targeting the invoice by invoice ID I get the 13 lines they show up in Power Query and they flow through to PowerBI when I Close and Apply, so I know the lines will flow from end to end when targeted. The table shows them and a Card on my report says 13. If I then add the same invoice ID filter to my card, it remains at 13. I refresh to check, it stays at 13, I go back to edit query and remove the invoice ID filter from the odata query I get back to the full table close and load and the report card, still with the invoiceID filter, drops to 9 again. It’s weird.
When I ask for all data it loses the lines, when I ask for just the missing lines they work fine.
I am stumped. Does anyone know what could be happening ?
