Blank Record Appearing in Power Pivot, How do I ensure that my Power Query script is filtering out all the Blank Records RRS feed

  • Question

  • Hi,

    I noticed once of my Fact tables in my Power Pivot model contains a blank record. I can't understand why.

    So I added a Filter expression to the underlying Power Query query, something like; -

    Text.Length("MyField") > 0

    However after refreshing the Power Query query which contains the above expression the blank record still appears within my Power Pivot table.

    Kind Regards,


    Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/

    Tuesday, April 14, 2015 8:22 PM


  • hi..

    As my understand, the blank record in Power Query will be return null value . So that, You try to use Text.Length("MyField" ) <> null.


    Wednesday, April 15, 2015 2:27 AM