Alternatives to direct database access

We are in the early stages of implementing Reporting Server. For now we are using Desktop to build some of our reports that we will use. I am working with our third party vendors to get at our data. One of our application vendors has our data in Amazon Aurora. He is currently providing us the tables and data through Metabase. I asked them to let us login directly to the database to pull it in to Power BI, but he is not comfortable with having us do that. What is a good alternative to get at our data?

I currently download CSV's from Metabase, then use Power BI desktop and Power Query to build the reports. Our users need to be able to use Refresh to get the latest data. I am new to this, but one idea I had was to use a system where generates CSV's are put in a location where we have access, then we pull those in. I need some guidance.