Forum Discussion
Query or Macro to delete rows
Hello, Is there a Delete Query in Power BI? Similar to Access when the row is deleted based on a logic. For example, if row 500 column C is blank, delete row 500.
v-sihou-msft that will remove rows in which all columns are blank (or null).
Yup. I'm importing the data from Excel sheets. I think I'll just have to do this manually in Excel and when imported to Power BI it'll be fine. I was just hoping there was a similar logic such as the one in Access.
Thank you both for your replies.