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
Anonymous
If your employees have a unique id (or any column you can rely on as unique) in the spreadsheet, you can make use of that column and filter out the employees you don't need. So, that way, Power BI will know to remove those employees from your data and you don't have to worry about them appearing in the dataset even after refresh.
Filter by values in a column | Microsoft Docs
Did I answer your questions? Give a thumbs up and accept this post as solution.