I have a dataset that contains 3 big tables and 10 small tables. 1 of the big table is directly pulling data from Oracle database, the other 2 tables are referenced by this 1 big table. I have also done a lot of Power Query editing, such as renamed every column. Settings in datasource of Oracle database is import, not DirectQuerry.
Now, the dataset refresh on service is triggered by restful Api with a Powershell script. It takes about 10 mins on average if it is the only dataset runs the refresh on the gateway, 16 mins if it runs the refresh with other dataset refresh simultaneously. My end client wants me to reduce the refresh time.
I installed my On-Premise gateway on a virtual server has 32GB ram and 8 cores.
Can you give me some other hints for making it faster?