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)?
I tried adding that to my MDX query in power bi & I got this error. Would you be able to assist?
Did you try removing Empty rows from Power Query (keeping your original MDX)?
Yepp, that worked! So that means as my data refreshes, it will pull in everything & then filter it to non-null values?
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
Yes, thank you for your insight. It is much appreciated.
