Forum Discussion
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.
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_DecklerCommunity 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-msftMicrosoft Employee
- ozmikeResolver 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.