Forum Discussion
Refresh Excel Data
Hi, I'm working with HR data that was given to me in an Excel spreadsheet. Some of the employees listed in the spreadsheet need to be removed from the dataset. I know that I can simply delete the...
Sorry I don't recall an article for this matter.
What's confusing you?
How about adding a list of only active employees and use it in your report? I think it's better this way
Hi Anonymous
You can use Power Query to replace those names by empty Cells, however the rows will keep coming back in the desktop, it is just the names that are going to be empty. Also if the Rows are in a specific range all the time then you can remove them in power query too.