Forum Discussion
Anonymous
3 years agoNot applicable
Power BI (or possibly another source) creating new rows with text in my Queries, ruins formulae.
In some of my Queries I am cleaning data by removing blank rows amongst other things. However, every so often (feels like every new time I open my computer) I notice that Power BI, presumably, is ins...
BA_Pete
3 years agoSuper User
Hi Anonymous ,
I may be oversimplifying this but, as your [Column2] contains your data's ID column ([App ID]) which presumably never contains null values in the actual data body, couldn't you just remove redundant rows by filtering on [Column2] <> null, instead of trying to remove a specific number of Top Rows?
Pete