Forum Discussion
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...
Did you try removing Empty rows from Power Query (keeping your original MDX)?
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!
You can just click on the drop down besides the Product Code Name column in Power Query editor and press Remove Empty. You can consider this as 'hard delete' since null vlaues won't be loaded to your data model.