Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Faster oracle database connection. The existing one is slow compared to the SQL Server one.

The existing oracle data source is extremely slow. I even installed the latest oracle drivers from oracle and that only saw a marginal improvement in speed. My other oracle apps using the same connector are very fast, but Power BI is extremely slow.
Status: Completed
Comments
fbcideas_migusr
New Member
Hello, we are early in 2016, and the ideas is not started, can we hope for some performance improvements shortly?
jfennessy
New Member
Hi, any updates on this improvement request?
mikejarod
New Member
One report I use has ~1 million rows, ~20 columns. Takes about 25 minutes to refresh from Oracle. If I dump the same data from a tool like TOAD it takes several minutes. Please improve this. We shouldnt have to vote on this...
fbcideas_migusr
New Member
any updates?
Mvp3
New Member
Maybe look at the attuinity providers, they are available through the SQL Server feature pack. You can maybe pull a deal for Power BI as well....
dbrowne
Microsoft Employee
You can always install and configure the Oracle OleDB provider and use that instead of the default Oracle connector in PowerBI. EG let Source = OleDb.DataSource("provider=OraOLEDB.Oracle.1;data source=//MyOracleServer/MySID;extended properties=""FetchSize=1000""", [Query="select * from ... )"]) . . .
kapil5121
New Member
Hi, Even for me..when I extract the data from oracle for few of tha tables,its loading very slow.like 50 to 60 rows per 5 sec...
shivasup
New Member
ORACLE data load is still SLOW like snail.. downloading data from SQL client works much faster.. any solution or a workaround? don't want to download plaintext and load it to Power BI
williamtamaro
New Member
Hello, any update? I have the same issue... ='(
mdmoo1978
Regular Visitor
It feels like it is getting worse, not better. Can we move this up the priority list?