Using "is blank" filter doesn't work - results in empty dataset (DirectQuery on SAP HANA View)

[Anonymous]

Hi dear community,

I'm trying a simple table report on an External Hana view (Get Data - SAP Hana database - DirectQuery mode , in default mode , that is "Treat SAP HANA as a multi-dimensional source" )
I've filtered my dataset to contain only a few records, with some records having characteristic X (lets call it that way for ease) with value, and some records with X being blank.

When I then put an extra filter (page / visual or report filter it doesn't matter) with X "is blank" , I expect to see only the records where X is blank, but instead I see nothing , no data at all , although there are records where X is blank...

Thanks already for any hints/help you can provide me!

kind regards,
Edwin Jacobs

[v-cherch-msft]

Hi @Anonymous

Please enable the option like this similar post and try again.

Regards,

Cherie

[Anonymous]

hello,

as per suggested, I turned on the option "Allow unrestricted measures in DirectQuery mode" via the options (and restarted Powerbi Desktop).

unfortunatly this does not solve the issue. Still same behaviour (filter to show only blanks yields in no records shown at all ).

Thanks for the attempt though! Anything else I can try?

kind regards,

Edwin Jacobs

[v-cherch-msft]

Hi @Anonymous 

I would suggest you update to latest version of Power BI Desktop.Then test again.If it still reproduces,please share some screenshot or more details for us to check.

Regards,

Cherie

[Anonymous]

Hi,

I updated from Dec18 to Feb19 version as suggested , but the error remains.

(ps : the new version appearantly doesn't have the  setting "Allow unrestricted measures in DirectQuery mode" anymore)

As requested , see below more details on the issue (with screenshots taken from the Feb19 Powerbi Desktop).

Thanks already for attempting to aid!

kind regards, 

Edwin Jacobs

Summary of the issue I’m facing (also with the newest Feb 2019 version of Powerbi, as well as 2 previous versions) :

 I’m connecting to a External Hana view on a Composite Provider *, using DirectQuery mode with the HANA database connector.

From the moment I add a certain filter (on  “SYS_ID – Task SLA” characteristic) to show only the records where this is blank, it returns nothing.

Detailed:

*The composite provider behind the HANA view has following structure:

(this tool lowers the screenshot resolution , so hope its still readable...  if not please ping me your email address, and I'll send a Word document containing larger version)

But I'm quite sure the issue is NOT with the composite provider, as with other reporting tools (eg. Business Explorer of SAP) I am able to make this filter to count the number of incidents , in the way I am not able to do with Powerbi (filtering out Task SLA sysid's which have values).

[v-cherch-msft]

Hi @Anonymous 

I would suggest you set the Fast Combine to 'Ignore the privacy...' and try again.If it is not your case,you may submit a support ticket.

https://powerbi.microsoft.com/en-us/support/

Regards,

Cherie

[Anonymous]

hi,

my guess is that Powerbi sends "is blank" in sql code to HAna as:  is null

where it should probably be sending it as = '' (2 single quotes)...

I've got a meeting with a MS support officer tomorrow ( SR number 119030426001309 ).

Will send a brief update here afterwards.