Forum Discussion

edhans's avatar
edhans
Community Champion
7 years ago

Service Report Differs from Desktop app - null rows

I know there was an issue in June with the NULL field and not being calculated properly, but it seems to still exist, at least in the service.    I have the following M code in a table: let So...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI edhans ,

Can you please share a sample file for test? I can't reproduce this on my side.
In addition, have you try to filter with other keywords?(e.g. " ", "")
Regards,

Xiaoxin Sheng

edhans's avatar
edhans
Community Champion
7 years ago

It goes to my SQL server, so not sure how I can provide a set of sample data. I would be glad to PM you the file if desired, but without the backend database, not sure how that would work.

 

I am 100% sure it isn't a "" or " " issue, because by simply setting the type to text (it is already text) fixes it, which is reminiscent of the other null bug that we had last month that is you reapplied the same data type to the field, subsequent handling of NULL worked correctly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi edhans ,

    Maybe you can open a support ticket to report and get better support for this:

    submit a support ticket

    Regards,
    Xiaoxin Sheng