Forum Discussion

ozmike's avatar
ozmike
Resolver I
9 years ago
Solved

Query Editor filter rows not working but Power Bi does ?

Hi 

 

I have a user here with an issue, I tested on his power Bi. In query editor if we filter on Surname either equal or contains - says no rows. If get out of the query editor and use a filter in power bi it works. The table is very big. We also tried key fields. Any Ideas. We are connecting to SAP HANA db direct connection.

  • ozmike's avatar
    ozmike
    9 years ago

    Hi

     

    I retested and was unable to reproduce the issue the user was having. I think what they were doing was filtering on surname say SMITH and then doing another filter on JONES and this brought back no rows. I will retest on the users machines. But you can close for now if it happens again I will repost thanks.

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    I do not have SAP HANA to test with, if it is a replicatable problem, I would post it as an Issue.

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee

    ozmike

     

    What is the power query formula of filter rows in Advanced Editor?

     

    Best Regards,

    Herbert

    • ozmike's avatar
      ozmike
      Resolver I

      Hi

       

      I retested and was unable to reproduce the issue the user was having. I think what they were doing was filtering on surname say SMITH and then doing another filter on JONES and this brought back no rows. I will retest on the users machines. But you can close for now if it happens again I will repost thanks.