I often write the sql statements that pull from our Oracle database to populate tables either directly in the power pivot data model, or through power query which then populates the data model. After...
For this use case you can use Power Update from www.power-planner.com. Free trial.
