Query Editor filter rows not working but Power Bi does ?

[ozmike]

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.

[v-haibl-msft]

@ozmike

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

Best Regards,

Herbert

[ozmike · Accepted solution]

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.

[Greg_Deckler]

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