Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Very Slow Oracle Connection Speed

Hello,   I'm trying to connect to an on-primise Oracle database. I followed this instrucution and installed ODAC and instant client.    This is the connection speed if I use sqldeveloper and each...
Need Help
Shaun2020's avatar
Shaun2020
Frequent Visitor
3 years ago

I have always had issues with the slow connection to an Oracle source.
The only way I found to get the data into the service was a sheduled spool using SQLcl and then using that csv as a source to load to the Service.

My ODBC load takes 2 hours, whereas the spool and load method takes a couple minutes. I'm currently testing the old ODBC method and it is again 2 hours. I have not bothered publishing. Nothing wrong with my network connection.

My original query uses a join, but the view is already joined, it just has way too many unwanted columns.

 

I would be interested if there were a way to use my own SQL query to select only my columns from Oracle, when using the Oracle Database as the source and hope it's faster. I cannot make my selection in the Power BI service, only the whole view, and I'm not the owner of the view to trim it to what I need.