@DaleB It seems both the methods you mentioned has his cons. If I had the choice in my company, I would have preferred to directly access the database and then import (Not Direct Query) the reports I need for the analysis. Providing source copies add one extra step that means additional supervision and management of data.
In your scenario, you know best what method can easily be implemented with less hurdles and training.
Whatever method you choose, we will fully support you in your decision 