Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi Anonymous 

     

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      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.