Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

How to prevent null values from loading into data model when importing data from cube with MDX query

How can I remove the null row from my MDX query results OR prevent null values from loading into my data model?    I'd prefer to prevent these records from loading rather than filtering out null va...
Need Help
Tips and Tricks
  • AkhilAshok's avatar
    AkhilAshok
    7 years ago

    Did you try removing Empty rows from Power Query (keeping your original MDX)?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks for the suggestion. I tried adding that to my query & running in SSMS. I get a memory error very quickly & I'm thinking its because my data source is so large?

 

Do you have any other suggestions? 

 

Is there a way I can remove the rows with a power query filter? I'd prefer to "hard delete" these rows, not hide them. 

 

Many thanks!

Anonymous's avatar
Anonymous
Not applicable
7 years ago

I tried adding that to my MDX query in power bi & I got this error. Would you be able to assist?

  • AkhilAshok's avatar
    AkhilAshok
    Solution Sage
    7 years ago

    Did you try removing Empty rows from Power Query (keeping your original MDX)?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Yepp, that worked! So that means as my data refreshes, it will pull in everything & then filter it to non-null values?

      • v-danhe-msft's avatar
        v-danhe-msft
        Microsoft Employee
        7 years ago

        Hi Anonymous,

        Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

         

        Regards,

        Daniel He