Different data result in Power query and in Data view in Power BI desktop

[tatochka]

Simple scenario. Oe table is imported in Power BI through ODBC. I filter one column in power query and get 1 row result. Then apply the same filter for the same column in Data view of power bi desktop and get no result. I am trying to solve this mistery for 2 days with no success. Any ideas?

[v-jingzhang]

Hi @tatochka 

Can you show the filter you set in both places? One possible cause is that in Power Query Editor it is case-sensitive while in Power BI Desktop it is case-insensitive. This may get different results after filtering. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[tatochka]

Here is the filter in power query that returns one row with "In Qc Review" status:

Same filter returns no rows in data view:

and "In Qc Review" is really not there regardless of filter. Here is when column sorted ascending:

That is with no data transformation, just one view pulled through odbc. Now, what is interesting after i removed all other colomns except statusName in Power Query that one row with "In QC Review" disappeared.

and it is really not there anymore regardless of filter. Here is after i removed all duplicates:

I am SO confused by all these.

[tatochka]

Just adding. Here is the data source connection  = Odbc.DataSource("dsn=Unqork BI Connector", [HierarchicalNavigation=true]). And data refresh didn't help.