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 inserting two rows into one of my Queries. One of which is a blank row and the other, above this blank row, is blank also except for two cells: - "Check Point Threat Extraction Secured This Document", and - "Get Original". While mildly irritating, the true frustration lies where the insertion of these rows changes from query to query, removing it from the previous one while moving it to another one. This messes up my Remove Rows step in my queries as I must change how many rows I remove from the query. This of course means that when I sent or publish the document, it may not run if these rows have been inserted in a new query since the last time I fixed the problem. Above are screenshots of the problem. Hopefully this is helpful. Thank you very much for you time in advance 🙂
