I am facing a peculiar issue in power BI Querying.
Suppose i have a table that is fetched form Odata feed. The table has 1000 rows and the table has a column called "TEST" which has values a,b,c,d,e which is spread across all the 1000 rows.
When I load the table to an Excel sheet by copying the table from Power BI to an excel sheet and apply the filter on the column so that i filter out TEST column for "a". Say we get 200 rows which have "a".
When i do the same in edit queries mode and i filter the TEST column for "a" in the query editor window and then load the table i get less rows. Around 180 rows which have "a".
I tried writing the query in excel Power query too but the result was the same i lose rows whenever i apply the filters in power Query.
Any suggestions on why this is happening will help.