Oracle connector slow. Tuning Oracle ODAC driver?

[FredrikJ]

Hi!

We have problem with slow connection to Oracle Database. We have an on prem Oracle database and using the Oracle connector i Power BI it processes about 5000 rows/second both from Power BI Desk and trough the gateway.  Extracting the data inside Oracle SQL Developer it processes about 100 000 rows/second.

Anyone who has solved the same problem? Is it possible to Tune the Oracle ODAC driver?

Regards

Fredrik

[v-kkf-msft]

Hi @FredrikJ ,

Please see if these documents are helpful.

Your Oracle data import in Power BI and Power Query is slow? 

Oracle data load speed into Power BI Desktop 

Very Slow Oracle Connection Speed 

Best Regards,
Winniz